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]
if you can provide the m code for this example, that would be awesome.
Thanks for the share!
I figured it out, see below screenshot as reference. You can create parameters for each argument shown below in yellow and do not need to place (") or (&) symbols. In my case, all I needed was a parameter to toggle the filepath and left the other arguments alone.