Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I see the path to the datasource from a Power BI report (web version, not desktop)? I am able to see the file name listed in the "view related", but how do I tell the directory/path this file is coming from?
Solved! Go to Solution.
@Anonymous You won't find a direct path persay, but you can go to the dataset of the report, click on the elipses "..." -> settings and look into the data source credentials area. But you would need the original file to see exactly what is being used in the dataset.
@Anonymous Still the case. Alternative thoughts. Get the credentials of the consultant user and log into Power BI as them. This assumes that they had creds in your company. Have the password reset and go explore how they set things up. Hopefully it is just a matter of adding your user to the workspace as an admin. (Hopefully they used an App workspace to share and not personal)
Alternatively, someone else should be an admin on the workspace.... I could never imagine rolling into a place and building reports without someone from the company also being an owner/admin.... Maybe check with whomever hired them.
Although one cannot get a link, one can find the location of the source data.
1. Go the dashboard and click on settings button that looks like gear and click on settings
2. In settings, click on datasets on the top menu.
3. Halfway to the bottom of the page click on Data Source Credentials.
4. This will open a dropdown item then click on show lineage view.
5. In lineage view, click on the source file of the chart you're looking for.
6. On the right it will display a link to the file, clicking on it will download the file.
9. Copy the link and trace the source of the file.
Hope this helps.
Hi @Anonymous,
Unfortunately there is no such an option you can use to determine what the original source is and where it come from on service.
Please feel free to vote for the idea on our ideas forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Yuliana Gu
Is this still the case? As being a user who was only "shared" a report, it's still not possible to see where that dataset resides?
Having a number of consultants who've created reports and dashboards for us...those folks having moved on...it's difficult if I can't determine where this data resides for a report that was handed off to me.
@Anonymous Still the case. Alternative thoughts. Get the credentials of the consultant user and log into Power BI as them. This assumes that they had creds in your company. Have the password reset and go explore how they set things up. Hopefully it is just a matter of adding your user to the workspace as an admin. (Hopefully they used an App workspace to share and not personal)
Alternatively, someone else should be an admin on the workspace.... I could never imagine rolling into a place and building reports without someone from the company also being an owner/admin.... Maybe check with whomever hired them.
@Anonymous You won't find a direct path persay, but you can go to the dataset of the report, click on the elipses "..." -> settings and look into the data source credentials area. But you would need the original file to see exactly what is being used in the dataset.
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.