Forum Discussion
Solved
How to switch sources within sharepoint folder
I'm using an Excel file with various tables as input source to my queries. As long as this file is stored on my local drive, I can simply switch to another file using "data source settings" - "change...
Just figured it out myself: Goto "Query Editor". On "Manage Parameters" select "New Parameter" and enter a name, a list of values and a current value. Then in "Advanced Editor" simply refer to that parameter, e.g.
File = Source{[Name=MyFileParameter,#"Folder Path"=MyPathParameter]}[Content]
Hi Guys,
new idea for it:
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Skip-Credential-Validation-for-Queries-Excluded-from-Report/idi-p/4748177
Please vote!
It means that you can exclude query to be refreshed not only in power bi desktop - also within power bi service without failing because of data source credentials.
Best,
Jacek