how to change source from sharepoint site to excel Workbook in power bi

[JoeBarry · Accepted solution]

Hi @Anonymous 

Import the excel into your report. Open Advanced Editor, copy the MCode and close and then go to the Sharepoint source Table open Advanced Editor and replace the MCode with the copied MCode from the Excel Table. 

If you had made transformations to your sharepoint data, make sure that you only add the MCode just from the let section up to the first transformation line.

Delete the original Excel table as you don't need it.

Thanks

Joe

If this post helps, then please Accept it as the solution