Forum Discussion
Get original SharePoint link from an uploaded .pbix
Within the organization we have been uploading many SharePoint reports straight to PBI Service.
How can I get the link to where the .pbix file is located in SharePoint?
Or is there any way to identify the path in SharePoint where it is connected to?
I imagine it is possible since when importing the pbix to the workspace from SharePoint a connection is created and when updating the pbix I correctly perform a refresh to the dataset without uploading the file again.
I am still trying to see if this is possible, but I am inclined to think that URL isn't stored anywhere. Read this article:
Refresh a dataset from OneDrive or SharePoint Online - Power BI | Microsoft Learn
Once the report is in Power BI, refreshes are not sync'd back to the file in SharePoint, so it seems to be a true upload, just as if you were to upload from your hard drive. That location info isn't stored.
The SP/ODfB upload just has the benefit of automatically scheduling refreshes.
2 Replies
- edhans
Community Champion
Unfortunately I do not think there is a way to do this. The report name and PBIX should be the same, so you might be able to track them down using Delve in your Office 365 tenant.
Best practice is to have a process for storing PBIX files where everyone knows where they are. Some orgs create a new Team just for this and store them in a different channel per workspace, and you can even create Private Channels for confidential PBIX workspaces - HR, Finance, etc.- edhans
I am still trying to see if this is possible, but I am inclined to think that URL isn't stored anywhere. Read this article:
Refresh a dataset from OneDrive or SharePoint Online - Power BI | Microsoft Learn
Once the report is in Power BI, refreshes are not sync'd back to the file in SharePoint, so it seems to be a true upload, just as if you were to upload from your hard drive. That location info isn't stored.
The SP/ODfB upload just has the benefit of automatically scheduling refreshes.