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 am trying to display additional metadata like Report owner information in a report. I have a data set that holds all the report names and their owners. How do I filter the dataset with the report name of the current report to display that information within the report? Is the report name or its id accessible from within the report?
For example: I have a report CustomerChurn. I have imported a dataset that lists
Report Name Owner Name
CustomerChurn John Doe
Regional Sales Jane Doe
Now I want to create a card that shows 'Report owner: CustomerChurn' within this report. That is possible only if I am able to filter based on the report name. Any suggestions/inputs will be of great help!
Solved! Go to Solution.
Hi @Anonymous,
I think you need to do some additional operations to get the report/dataset related information.
After you published the pbix file, you can go to power bi service workspace to find out the report you published and correspond id(workspace/report/dataset)
If you successfully got these ids from the published report, you can open the raw pbix file on desktop side and add a query table with a web connector that points to power bi rest api to get metadata that you mentioned.
Pull data from a REST API Authentication
Then you can format and transform received information and use them to create a metadata table for further analysis/design and publish to power bi service to replace old version report contents.
Regards,
Xiaoxin Sheng
"Report owner" is not a thing. You probably mean "person who has registered the dataset for scheduled refresh through a connection on a gateway" or "person listed as the support contact for an app".
The latter is already available in the Power BI service user interface. So you probably just want to use that instead of introducing yet another place with that information and risking user confusion.
Thanks for the respose! Yes we can assume the owner is more like the support contact. However instead of manually assigning the same in PBi service interface, I want to dynamically set it from a defined dataset (more programatically than manually). That is where I wanted to know how to pull it from the dataset without knowing the current report name for which I want to assign this support conatct.
Hi @Anonymous,
I think you need to do some additional operations to get the report/dataset related information.
After you published the pbix file, you can go to power bi service workspace to find out the report you published and correspond id(workspace/report/dataset)
If you successfully got these ids from the published report, you can open the raw pbix file on desktop side and add a query table with a web connector that points to power bi rest api to get metadata that you mentioned.
Pull data from a REST API Authentication
Then you can format and transform received information and use them to create a metadata table for further analysis/design and publish to power bi service to replace old version report contents.
Regards,
Xiaoxin Sheng
You cannot currently manipulate that information programmatically. Raise an idea.
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.