Forum Discussion
Changing To A New SharePoint List
Hi Ian,
Its seems like you will have to adjust some steps in the Power Query editor.Try to see if you can simply switch List1 to List2.
Feel free to share your Advanced Editor code here, and I'll have a look.
FYI, you can also save your excel on onedrive/sharepoint and connect to it:
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-linksregards,
Robbe
Hi Ian,
Its seems like you will have to adjust some steps in the Power Query editor.
Try to see if you can simply switch List1 to List2.
Feel free to share your Advanced Editor code here, and I'll have a look.
FYI, you can also save your excel on onedrive/sharepoint and connect to it:
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
regards,
Robbe
Thanks, Robbe. I've gone in to Query Editor. Then in the APPLIED STEPS section on the right I've clicked on the small cog next Navigation and changed the 'Specify a resource to navigate to' and clicked on List2. After applying and refreshing the report looks to have update correctly. Magic!
Thank you.
Ian