Forum Discussion

nirajdubey's avatar
nirajdubey
Advocate I
10 years ago

Connecting cubes with large datasets to Power BI

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.

 

 

 

 

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

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

    • nirajdubey's avatar
      nirajdubey
      Advocate I
      10 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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..