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 can give a network file path using Poawer BI parameters and use the parameter to get the Excel data file.
Source = Excel.Workbook(File.Contents(Parameter1), null, true)
I can save this report to the PBI Report Server (in-house).
Then I changed the path to be the value from a table column and in PBI Desktop it works fine.
Source = Excel.Workbook(File.Contents(QueryName{0}[ColumnName]), null, true)
But when I try to save (publish) this to the PBI Report Server (October 2020 version) I get an error message "An error occured when trying to save to Report Server..."
Can anyone help me with how the give the data file path stored in a table?
Thanks in advance.
Hi @anandav
Does my reply solve your problem? If yes, kindly accept it as the solution. If you find other solutions, you can also share them here to help other users in the future. Thanks.
Regards,
Jing
Hi @anandav
You may try the following steps:
1. Right click on the column which stores the data file path and select Add as New Query. This will generate the column into a new list. I call this list FilePath.
2. Create a parameter Parameter1, set Type > Text, Suggested Values > Query, Query > FilePath.
3. Modify the Source by using the parameter: Source = Excel.Workbook(File.Contents(Parameter1), null, true)
Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
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.