The Power BI connector has really been useful for our company and being able to provide our users the ability to view inspection data and see trends to help with decision-making.
The issue is whenever we try it on our daily inspections, the connector fails to refresh as it cannot pull large amount of data. I hope SafetyCulture would consider adding a ‘Completed before’ and ‘Completed after’ parameter on the connector.
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.
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.
Already have an account? Log in with your username and password, or with your SafetyCulture account.
Don't have an account? Sign up or log in with SafetyCulture.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
