Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I have a process that creates bunch of CSV data of predictable shape and contents. I have a report that makes it all pretty.
To do so, I have created PBIX file where I defined a string parameter called ReportDataFolderPath. I am using it to load CSV from it using File.Open:
let Source = Csv.Document(File.Contents(ReportDataFolderPath & "\RELATIVE\file.csv"),[Delimiter=",", Columns=19, Encoding=65001, QuoteStyle=QuoteStyle.Csv]),
...
I save the PBIX design file as PBIT template, then open template, it prompts me for the path to the new location of the files, and loads the data just like I want to.
I am now wondering, is there a way for me to somehow figure out a path to where the PBIT or PBIX file is being opened from, and automatically set the relative path to the CSV files.
If this was possible, I can pre-copy my PBIT or PBIX file into the location where my CSV files are created and just automatically open it.
I tried doing this:
let Source = Csv.Document(File.Contents("\RELATIVE\file.csv"),[Delimiter=",", Columns=19, Encoding=65001, QuoteStyle=QuoteStyle.Csv]),...
But it does not work as the File.Open needs an absolute path.
Any idea of whether this is possible?
Solved! Go to Solution.
Hi @Anonymous,
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
It is possible by using python script:
https://bizkapish.com/power-query/discover-relative-path-to-power-bi-desktop-file/
PBIT template solution works well for me:
I save the PBIX design file as PBIT template, then open template, it prompts me for the path to the new location of the files, and loads the data just like I want to.
Hi @Anonymous,
Based on my test, I have created a parameter and it seemed you need to use the full file path to set the parameter:
Regards,
Daniel He
Daniel, not sure what this proves - I already know that one must use absolute path to those functions
My question is - is it possible to retrieve the path to where PBIX/PBIT file is stored so that it can be used as input to functions to construct other paths?
Hi @Anonymous,
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |