Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
. 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 ?
Solved! Go to Solution.
Check code in The Advanced Editor and take a look at this link.
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.
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
Hi fabien,
unfortunately, I am not available for TeamViewer right now...
Have you tried the Refresh-Button as well?
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.
Check code in The Advanced Editor and take a look at this link.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |