How to change source from local excel file to Sharepoint

[binayjethwa]

Hi , 

I have currently all my transformations , data model and measure coming from and prepared from excel data source in Power bi Report server desktop.

Now how do i change my source from Excel to Sharepoint folder and also retain data model, transformations and all other measures /calculations that are already created.

Thanks in Advance.

Note: I need to make the changes in Power BI Report Server(On Prem) not Power BI Desktop.

Thanks,

Binay

[Idrissshatila · Accepted solution]

Hello @binayjethwa ,

check if this solution works for your case https://community.powerbi.com/t5/Power-Query/Change-Data-Source-from-offline-excel-to-SharePoint/td-...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Kaldon_Alkalsy]

It worked great i Actually needed to the do the opposit to point the report to read from local drive due to the new limitations from microsoft