Forum Discussion
Discrepancy in AS measure between Excel get data and PowerBi get data
Hi cindy,
Based on my search, I do not find the document list the data model limitation in Power BI desktop. But there is a limitation in Power Query: Maximum number of rows filled to worksheet is 1,048,576. As Power BI will generate backend query when we get data, I guess the issue might be the number of rows exceeds the Power Query allowed rows.
In your scenario, please get data from the same SSAS data source under Power Query tab in Excel, check if the same issue occurs.
Best Regards,
Qiuyun Yu
Thanks v-qiuyu!
I'm sorry I forgot to mention about my other BI graph that was able to handle 109M and 1.26T data. (see first image below). Nevertheless, I tried, as you suggested, getting data from the same SSAS data source under Power Query tab in Excel, but it stopped at around 1.07M and returned an error message.(see 2nd image below)
Thanks for your support. :)
More than 1.07M
Hi cindy,
From your original post, you mentioned "loading stopped at 1.07M records into the model in desktop". But in your second post, you said "other BI graph that was able to handle 109M and 1.26T data", it means you can load data more than 1.07 M in desktop, right? Also can you tell us which visual can't handle 109M data?
Best Regards,
Qiuyun Yu- Thank you Qiuyun Yu!
My apologies if I cannot give you an accurate info until I return to work on the 2nd of January.
Regards,
Cindy
