Reply
gdecome
Helper III
Helper III
Partially syndicated - Outbound

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
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

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.

avatar user

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.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)