Forum Discussion
Helper IIChange source from local Excel to SharePoint Site
I have a couple video tutorials that walk through how to do this. It depends on if you're using the file connector or the folder connector.
Move file source to SharePoint folder: https://youtu.be/5SFxHffE2TA
Move file source for a single file to SharePoint: https://youtu.be/wHzrBkbUBgM
You basically just update the path its looking for in the query, the trick is getting the correct path to use.
Community ChampionHi haniizz
All have to be done in Power Query with editing the M code. If you know how to do it then go for it otherwise it would be easier and faster if you just create a new connection then copy paste the visuals of the pages report into new pages. Delete the old ones and republish your report.
haniizzHi aj1973
thank you for your prompt response
Actually I'm not good in M language, if you can help me I'll appreciate, the copy and paste I feel like its going to take forever- aj1973
If you can send me a sample of your excel file and the M code that you've applied to import it then it would be faster and easier. Thanks.