Reply
Frequent Visitor
Posts: 10
Registered: ‎02-26-2018

Getting current folder of the PBIX file

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?

Community Support Team
Posts: 2,061
Registered: ‎06-24-2018

Re: Getting current folder of the PBIX file

Hi @danielodievich,

Based on my test, I have created a parameter and it seemed you need to use the full file path to set the parameter:

1.PNG

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 10
Registered: ‎02-26-2018

Re: Getting current folder of the PBIX file

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?

 

Community Support Team
Posts: 2,061
Registered: ‎06-24-2018

Re: Getting current folder of the PBIX file

Hi @danielodievich,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.