PowerBI chainging source

[fabienzan]

. We have a PowerBI report pointing to Excel all working well. We won't to re use the layout and repoint to a different spreadsheet which as the same structure as the original one. Would you know how to do that ?

[theitguy]

You want to change the path of the source to repoint to another spredsheet?

If yes, go to Main Page, Tab "Home", choose "Edit Queries", select the query for which you want to change the source. Then click on settings icon of the transformation step called "Source". Here you can change the path.

[fabienzan]

I tried to do that but it doesn't refresh with the new data.

My email is fabienzan@gmail.com . Happy to do a teamViewer about if you have 5 mns

[theitguy]

Hi fabien,

unfortunately, I am not available for TeamViewer right now...

Have you tried the Refresh-Button as well?

[fabienzan]

I have done the refresh. I am actually pretty experience with BI toolset but PowerBI is new and I understand the process but can't seem to figure out why it is not refreshing with the new data once repointed.

[v-chuncz-msft · Accepted solution]

@fabienzan,

Check code in The Advanced Editor and take a look at this link.