Getting current folder of the PBIX file

[Anonymous]

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?

[lpriceFTW]

Did you every figure this out? Hoping that in 5 years, PBI would implement a solution to achieve this.

[brodoplovac]

It is possible by using python script:
https://bizkapish.com/power-query/discover-relative-path-to-power-bi-desktop-file/

[shammadali]

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.

[v-danhe-msft]

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

[Anonymous]

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?

[v-danhe-msft · Accepted 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