Forum Discussion

christianjohan's avatar
christianjohan
Frequent Visitor
6 years ago

Relative file path in Power BI

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?

2 Replies

  • 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.