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