Forum Discussion

gs75's avatar
gs75
New Member
7 years ago

SSAS Connection

Dear all, i'm trying to connect to an OLAP cube. I selected measures and dimensions and I clicked Load. I see the loding message since 15 minutes..  
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi gs75,

 

If I understand your sceanrio correctly that the progress of the loading lasting more than 15mins and it cannot load the data and not show error message either?

 

What size of the data you want to load? Is it very large?

 

Best Regards,

Cherry

  • gs75's avatar
    gs75
    New Member
    7 years ago

    Hi Cherry,

    Thank you for your reply.

    Yes, this is exactly my scenario. I'm trying to upload lots of data. I was successful with a subset of 500,000 lines. Loading started and took 5 minutes. In the first scenario, the upload did not start. I was used to using performancePoint to create dashboards from cubes and I always had all the data available. What is the data size supported?

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi gs75,

       

      Which mode do you use when you connect SSAS? Live connection or import?

       

      Currently, there is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset. 

       

      In addition, if your data source is very large and you use import mode, it will take some time to load.

       

       

      Best Regards,

      Cherry