Connecting cubes with large datasets to Power BI

[nirajdubey]

I am facing problem when connecting cubes with large datasets to Power BI, through Power BI Desktop. The smallest cube I want to connect is based on fact table having 5 Million rows. It gives me a timeout expired error, error text is "The XML for Analysis Services Request time out before it was completed". I have installed Power BI Desktop on the same machine on which SSAS is installed. However I have tried with some smaller cubes and they are okay. Somehow I was able to connect a cube with 5 million rows, but I had to leave some of dimensions which were having large number of records.

[Greg_Deckler]

Are you using DirectQuery or are you importing all of the data into Desktop?

[nirajdubey]

we are importing all data, as coonect live is not supported for SSAS 2008.

[Seth_C_Bauer]

@nirajdubey Be aware that if you are able to load the data into the Desktop there is a PBIX file size limitation and you cannot  exceed 250mb. In which case, you wouldn't be able to publish the file to the Service for dashboards and sharing..

[lcullom]

For pre-built SSAS cubes that work with dozens of different, enterprise applications for IT, check out https://northcraftanalytics.com.  Then, you'll be able to query Terabytes of data quickly without being constrained by client-side memory limits.  All of Northcraft's solutions are built on the Microsoft BI stack.  The YouTube channel shows many different examples as well - https://youtube.com/user/northcraftanalytics