Good Morning (or Afternoon),

Thanks for taking the time to read this question.

I have used the parameters as shown in Ch23 in "M is for (Data) Monkey" to allow the files to be moved as required in my PQ / PowerPivot workbooks very extensively.

I have imported the excel file into Power BI Desktop (PBI) from a folder on my desktop and also a folder on my OneDrive.

I have been unable to get either version working. The parameter in the query editor resolves to an HTTP address to my OneDrive in both cases - and neither case works.

Is there some way of doing this in PBI?

If I am ever in a position to use this for work the files will need to be found on a network server so the data can be shared and updated.

Any suggestion you may have will be gratefully accepted.