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 a report created in PowerBI Service based on an Excel file from Sharepoint Teamsite. The whole teamsite address has since been moved, is there anyway I can change the Excel file link?
Solved! Go to Solution.
Hi @Anonymous,
As it is not available to view the data source path on Power BI servie, no matter whether the report is created on desktop or service, we are not allowed to edit the data source directly on service. You may need to re-create the report as suggested by guavaq. You could check this idea Ability to change the data source connection string from PBI service and vote it up.
By the way, the only way to change the connection string from Power BI Service is using the API Set All Connections. This API only supports DirectQuery datasets.
Best regards,
Yuliana Gu
Hi @Anonymous,
As it is not available to view the data source path on Power BI servie, no matter whether the report is created on desktop or service, we are not allowed to edit the data source directly on service. You may need to re-create the report as suggested by guavaq. You could check this idea Ability to change the data source connection string from PBI service and vote it up.
By the way, the only way to change the connection string from Power BI Service is using the API Set All Connections. This API only supports DirectQuery datasets.
Best regards,
Yuliana Gu
Hi @Anonymous
If you go into the Query Editor, and then click on your table that has the Excel file.
Then in the applied steps, the first step should be the Source. Click on the Gear Icon next to the Source, which should then bring up the location of the Excel File in SharePoint.
Now change this to your new location. And you should be good to go.
You can verify this once after changing the source if your table loads in the Query Editor.
If it does click Close and Apply.
And you are good to go
Hi @GilbertQ
As mentioned in the post, I created this report directly in PowerBI Service, not in Desktop, so do not have the query editor...
Hi @Anonymous
Apoligies for missing that.
I am not sure how to change it then. Besides re-creating the report from the start again.
No problem @GilbertQ! That's what I'm afraid of, but thought I'd post here in case anyone else had gone through the same issue
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.