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