CONCATENATEX and Web URL to execute LogicApps HTTP Request from PowerBI

[vornr]

Hi all,

I am looking at creating a URL on a PowerBI page which (when clicked) executes a Logic App (HTTP Request) to perform tasks within a SQL DB. For this we would require parameters to be passed from PowerBI for the Logic App. 

I was looking at creating a web url on a PowerBI dashboard which concatenates values from a slicer, e.g. "www.logic.azure.com/workflows&CustomerID=1&CustomerID=2&CustomerID=3&LocationID=444. This would then execute a Logic App HTTP Request to perform all necessary downstream activity.

I have hunted around and found a few forums posted and know CONCATENATEX can be used in a calculated measure to achieve the required string, however it cannot be done for a Web URL (calculated column) unless including all values from the slicer, (which is not suitable).

Has anybody found a solution/workaround for this?

Thanks in advance!

Vaughan

[v-chuncz-msft]

@vornr,

As far as I know, there isn't an available way. You may submit an idea.