Forum Discussion
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 the pivot model (adds a table). The table doesnt show in Power Bi when i refresh the data source (But data is updated).
My first idea was to replace the data source with the "new" updated one but doest seems to work ,just get two data sources with the same name. Best practice would be......?
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
8 Replies
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 doesn't work anymore.. Does anyone know how to solve this?
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
That link doesn't go to any specific page, but instead redirects to a support welcome page (for me as a user in the UK, it's redirecting to a en-us support landing page).
Here is a screenshot of what I see when I follow the link for a working solution
