Relative file path in Power BI

[christianjohan]

Hi I have tried this solutions and it works as intended. https://stackoverflow.com/questions/52878319/load-data-into-power-bi-from-relative-path

I have tried to make it a bit more automatic and failed. This is the code i have tried:

let
    Users = Folder.Contents("C:/Users"),
    CurrentUser = Table.FirstN(Table.Sort(Users,{{"Date accessed", Order.Descending}}),1)[Name]{0},
    FilePath = "C:\Users\" & CurrentUser & "\Folder\Folder\",
    Source = Csv.Document(File.Contents(FilePath & "Data.csv"),[Delimiter=";", Columns=265, Encoding=1252, QuoteStyle=QuoteStyle.Csv])
in
    Source

Everting loads and works perfectly in power query. But when I press close and apply i get this error message:

"Failed to save modifications to the server. Error returned: 'Expression in partition 'n/a' in table 'n/a' references an unknown entity.'."

Does anyone have any ideas?

[mahoneypat]

Another approach to consider is making a pbit file that prompts the user for the path to the needed file or folder.  Please see this article.

https://hoosierbi.com/2019/04/07/template-files-are-an-under-sung-feature/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

yes, had the same recently.  Start over with a fresh Power BI desktop file and recreate your queries.

Seems like due to the many different testing attempts somewhere the meta data gets stuck, and the only way to unstick it is to start over.

Also: Whaaa? 265 columns? you're asking for trouble.