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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
shoskins
New Member

Dynamic data URL per Workspace

Hello,

 

I am developing a new Report using Power BI Desktop. I have 3 different environments (dev, test, prod). The dataset is connected to a different database per environment and the data represents records managed from a website. I am using DirectQuery to access the data. I have reference numbers that I need to link to the appropriate website based on the associated environment. 

 

My question is, how do I dynamically build a URL per record and include page specific querystrings as part of my resultset? Currently, I can only link to a single website using a hard-coded URL and drop in the querystring information dynamically. I haven't figured out how to swap the domain per environment.

 

Currently I have a database table with a setting for each domain, but I can't figure out how to add that column from the unrelated table to the table that has the correct querystring information.

 

Example:

I have a reference number of 2022-123 and that reference number needs to link to the correct website of "https://devurl.com/t/#GUID#" for the dev workspace. It then needs to link to "https://testurl.com/t/#GUID#" for the test environment.

 

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

I have the same issue. I can use the Power BI Rest API to get urls, but I need to have a way to check what workspace that I am in so that the links can update accordingly. The only thing that I can think to do is to setup a parameter and manually change it depending on which workspace that I am deploying to. This is a hassle and it could cause issues.

steven_cs
New Member

Hey guys, 

 

anyone a solution for the topic. I have the same problem. 

 

 

v-yingjl
Community Support
Community Support

Hi @shoskins ,

how do I dynamically build a URL per record and include page specific querystrings as part of my resultset?

When you use DirectQuery mode to connect to Power BI datasets from Power BI Service, there is no data stored in Power BI Desktop so I'm not certain what is your expected output.

 

I can only link to a single website using a hard-coded URL and drop in the querystring information dynamically.

Could you please share more details about it like how did you get it by steps.

 

In addition, based on the example shared by you, I have known that each workspace has its specific web link but seems like we could not get workspace content using this link by Web connector in Power BI Service directly.

 

Best Regards,
Community Support Team _ Yingjie Li
 

shoskins
New Member

Yes, and I am currently using that to target a different database per workspage and that's working fine.

lbendlin
Super User
Super User

Does your Power BI tenant support Deployment Pipelines?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors