Forum Discussion
Solved
Replace Data Source?
Hey, Im using an excel file (with pivotmodel) as an data source for my Reports in Power Bi. Scheaduled data refreshes through Personal Gateway works fine but problem arises when i do changes to t...
The following link has the instructions for replacing an existing file. There are also additional Notes on structural changes and how Power BI handles them.
https://support.powerbi.com/knowledgebase/articles/655108
The link does not work, does you know how to solve this?
Use advanced editor of the Query
http://community.powerbi.com/t5/Desktop/Change-excel-data-source-in-Power-BI-report/m-p/50704#M20286
Thanks - that does it. Too bad there doesn't seem to be an easy way to change a connection en masse - for instance, if you import a bunch of Access tables and then change the location of the Access file - seems like you have to either individually edit each query, or start over.
