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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.