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
