Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Load Static Excel Data into Power BI report without refresh on the service

Hello Experts,   We have a requirement of developing a Power BI report which will take some data from an excel sheet and some from an MDX cube. Basically the excel data is the historic data and wil...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

There are some limitations to put imported data and data with live connection together in the same dataset in Power BI.

When connecting live in the Power BI, it is disable to connect other tables outside.

How about importing excel data and SSAS MDX data in the same dataset with Power BI Desktop, then configure schedule refresh only for SSAS MDX data?

 

Best Regards

Maggie

 

 

TheMindGymnast's avatar
TheMindGymnast
Frequent Visitor
7 years ago

Hi Maggie

 

That won't work though for the reasons outlined above. The service will still lokk for the file and won't permit refresh as the gatewway will not be properly configured even if load is disabled in desktop for the file.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I'm facing the exact same issue... have you managed to find a solution?

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

       

      Unfortunately, i was unable to find a solution to this using Power BI.

      Eventually, i had to import the data in SQL Server table and then use the same in Power BI.

       

      Regards,

      Chetan