Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
TL;DR: Refreshing datasets (on demand and scheduled) in Power BI Service are only partially loading from the source without prompting any errors.
Similar to this post. I have commented there as well.
I have a collection of reports all suffering from the same issue. Here have been my reproduction steps:
From this point, I download the now-incorrect .pbix and seach for common themes in the partially loaded data. I have noticed that some of the queries will be at exactly 1000 or 2000 rows of data (when the underlying SQL tables are definitely larger than this). Is there possible batching or chunking of data that is erroneously thinking it is complete?
Supplemental Information:
Some of my tests and results:
Next tests:
Any further ideas or suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.