Forum Discussion
Is the data refresh an atomic operation?
ashishrj Thanks :) You can just upload a .gif
I am specifically asking about a single report (pbix file) that has multiple data sources. I am wondering what will happen when a single data source in that report fails during the refresh.
Will the refresh for that report fail?
For example:
- In my report I connect to Google Analytics and Salesforce
- I uploaded the report to Power BI and set the refresh schedule for once every 24 hours
- When the refresh runs, the Salesforce API rejects the request, but the Google Analytics API returns data correctly
I can't be certain but that shouldn't be too hard to test out, I will probably setup a simple test and try it out. Basically, setup two SharePoint Online lists with a couple columns and a couple rows of data. Import into Desktop via 2 Power Queries. Schedule a refresh and let it refresh and succeed. Add a row to the first list, delete the second list. Let the refresh go again and see.
My initial impression is that it will fail, but it may refresh the first list. If it does refresh the first query, it would be interesting trying it where the first list is the second query to see if once it hits an error, does it continue or bomb out?
I can say that the ability the schedule a refresh is dependent upon ALL of the queries being "refreshable". For example, I had a query that I ported over that ran SQL code. It wouldn't refresh automagically in old O365 Power BI but it did allow me to schedule a refresh and all of the other queries refreshed automagically but that one had to be refreshed manually. But, in new Power BI, it wouldn't even let me schedule a refresh because that one query was not "refreshable". Not sure that is definitive for your case but I have seen that behavior.