Discrepancy in AS measure between Excel get data and PowerBi get data

[cindy]

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 PowerBi get data from the same cube, the loading stopped at 1.07M records into the model.  

We do our ELT from Oracle DB to SqlServer 2014, then deploy our AS to SqlServer2014.

I would appreciate your help so much.

Thanks,

Cindy

[v-qiuyu-msft]

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

[cindy]

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

[v-qiuyu-msft]

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

[cindy]

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