Forum Discussion
Dynamic URL filter based on value from Salesforce?
I was able to figure this out. Here is an example from my Hyperlink
?filter=POS_CUSTOMER_DIMENSION_V/PARTY_ID eq '" & Unique_Account_ID__c & "'"
markjohnson952, Not very clear to me. Refer this doc can help you
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
I did reference that article and I am unsure how to make the filter "dynamic." To hopefully provide a better understanding of my problem, I have attached a few more screenshots.
The first picture is what the embedded Power BI report looks like in Salesforce Desktop. That report filters to the account being viewed and it works properly.
The second picture is a custom field I created in Salesforce to hopefully get this report to work on the Salesforce mobile app. The field creates a link in Salesforce where the user clicks it on the account page and it then opens the Power BI report in the Power BI mobile app. I cannot get it to filter to the account the user was viewing in Salesforce. I am attempting to get it to work with the Hyperlink with this filter in the URL "&?filter=POS_CUSTOMER_DIMENSION_V/SALESFORCE_ID eq 'Record.ID' "
That same filter works in the desktop app for Salesforce.