Forum Discussion
Discrepancy in AS measure between Excel get data and PowerBi get data
Hi everyone! Using Excel get data from a deployed SSAS cube (tabular), I was able to extract 1.7M records into the Excel sheet which is the exact count from the Oracle DB source. However, using...
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