Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gdecome
Helper III
Helper III

Getting information about the environment (App or Workspace Name)

I have a report published in different Workspaces/Apps and I need to know where I am, when accessing the report, to control the behavior of some visuals. Is it possible to get this kind of information (e.g. using API) so I can use it in DAX?

4 REPLIES 4
Anonymous
Not applicable

I have a similar requirement.  It would be great if the report could automatically switch Datasource depending on which environment the report is in.

amitchandak
Super User
Super User

@gdecome , Not very clear on exact need.

But power bi cmdlets and Rest API can help

https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

 

rest api

https://docs.microsoft.com/en-us/rest/api/power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for your feedback ... in fact, when the user opens the report (Power BI Services), I need to identify the App or Workspace where the report is coming from (since the same pbix is published in different workspaces). I tested some REST API but I don´t think it is a solution for me because they are getting existing information in the environment, for example, I can get a list of reports in Workspace ABC but I need to inform the Workspace ID. It would work for me if I have an API returning the ID where I am at that moment. Anyway, I will try a simple approach with Parameters in Power Query. I can publish it in different workspaces and then I can change the Parameter (Dataset/Settings in PowerBI Services) and use it for my logic. Just need to remember updating the Parameter when I publish the report again but it is not a big deal.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.