Power BI Service - Scheduled refresh issue or Glitch??
I am experincing strange behavior on scheduled refesh on my power BI report. I have power BI pro Account and my power BI file is about 34 MB on size (Import mode) scheduled 8 refreshes a day, takes about 5 mins to refresh. Been arounds for more than 2 years.
We started experinceing some data issues on reports for last few months and the the problem would automatically resolved after next refresh. After some refreshes, seems like power BI would load only partial data into its dataset. When I check the refresh schedule it says completed successfully with out any error but the report would not display all the data. Then if I go and download the same file from Power BI service and open on my desktop I can see all data, Problem would saty there until next refresh and if we refresh again problem would go away. Has anyone experinced similar issues or if there is any limit of power BI that causing this issue?
This problem is very intermittent and most of the time next refresh would automatically resolve the issue. Any help would be appricaited.
For me I found it was the timming of the refresh of my Azure SQL data warehouse. This had not finished refreshing before my BI report started its refresh. This caused it to load up some of the tables blank. The warehouse had grown in size enough over the last couple of month to cause the refresh time to stretch out longer. Hence why I did not have this promblem when I first published my BI report. @SubashGtm Something quick and easy to check any how.