Access the current report name from within the report

[Anonymous]

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!

[lbendlin]

"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.

[Anonymous]

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. 

[Anonymous · Accepted 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 

Power bi REST API/Datasets 

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

[lbendlin]

You cannot currently manipulate that information programmatically. Raise an idea.