Dynamic data URL per Workspace

[shoskins]

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.

[Syndicate_Admin]

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.

[Anonymous]

Hey guys, 

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

[v-yingjl]

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]

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

[lbendlin]

Does your Power BI tenant support Deployment Pipelines?