Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |