How to add a url in the report which is generated based on the url of one website

[bingo]

In detail, I embeded the powerBI report to one website, the report is one part in the page. In the report, I show one url which can guide users to one new website, but the url should not be fixed, but to be generated based one the url of current website dynamically. For example, when the report is embeded in the website (bus.aa.com), the generated url should be tour.aa.com/order/detail/XXX, but when in the website (train.bb.cc), the generated url should should be train.bb.cc/order/detail/XXX. Can this need be achieved? And how to do?

Thx.

[TomMartens]

Hey @bingo ,

unfortunately, this is not possible.
The things that are dynamic are either calculated columns or measures. Calculated columns or measures are agnostic of the hosting application, for this reason, you can not ingest the url into the data model.

Maybe you use the function USERPRINCIPALNAME to determine the url based on the user that has authenticated to the underlying data model.

Regards,
Tom