Forum Discussion

nirajdubey's avatar
nirajdubey
Icon for Advocate I rankAdvocate 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 ti...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

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

  • nirajdubey's avatar
    nirajdubey
    Icon for Advocate I rankAdvocate 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..

      • lcullom's avatar
        lcullom
        New Member
        7 years ago

        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