Power BI Connector - Additional Parameter

Hi Camille, thanks for making this suggestion.

For large data sets, the Power BI connector is not our recommended data export method.

If your company has a data warehouse, we suggest using our data feed APIs to ingest SafetyCulture data and then perform analysis in Power BI by connecting to the data warehouse. https://developer.safetyculture.com/reference/data-feeds

If you do not have a data warehouse, we suggest exporting the data using our Exporter tool, then performing analysis on the data you have downloaded. Exporter supports fast incremental refreshing of data and a variety of output formats including SQL and CSV. https://help.safetyculture.com/en-US/000070/

Thanks,

Austin

Our company does have a data warehouse however that means I need to rely on our IT team to build data models which takes too much time. From what we’ve experienced because the ‘inspection items’ data come in rows, it seems they can only build a data model for similar looking templates.

If only the Power BI connector had a more efficient way of filtering out the data, we could use it for more reports in the business and one is having a ‘Completed before’ and ‘Completed after’ parameter.

I agree that there should be a Conducted Before/After and Completed Before/After option. As this Power BI connector uses the API, it would also allow us to filter data by that method in other integrations. I actually added this manually into our Power BI dashboard as well as a parameter for sites to choose 1, 3, 6, 12, and 24 months so it filters the completed inspections by that timeframe backwards.