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.


Suzanne