The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
. 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |