mitchandsuzy
New member
- Joined
- Jan 5, 2016
- Messages
- 6
- Reaction score
- 0
- Points
- 0
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
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