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.
Hello,
I would like to find the dataset used in a power bi report.
What I do is as follows:
1- open power bi report
2- edit queries menu
3- only available option is Data source settings
4- A window comes up asking: Select a dataset to create a report
- In this window there is a list of datasets
p.s. If I know the dataset name, then from there I know how to find the source.
It's just that from the report, i do not know how to find out which dataset the power bi report is using.
Thank you
Solved! Go to Solution.
Hi @Anonymous
Is this report live connected to Dataset in Power Bi Service?
If so you can publish it to the service and click on View Related.
I don't think that there is any thing in the PBI Desktop that will provide you with this info.
You can also just look down at the very bottom of the Power BI Desktop window, and in the bottom right it will say "Connected live to the Power BI dataset..." (and give its name).
Hi,
Hi @Anonymous
In Query Editor Select any query in the Query Pane to your left and look for Advanced Editor in the Home Ribon, this will give you the M syntax for this Query including the source of it.
I think you are referring to do doing this from the dataset window.
As mentioned earlier, in desktop report I do not get the options you mentioned i.e. query editor...
To confirm, I would like to find out which dataset the desktop report is using
Thank you
Hi @Anonymous
Is this report live connected to Dataset in Power Bi Service?
If so you can publish it to the service and click on View Related.
I don't think that there is any thing in the PBI Desktop that will provide you with this info.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |