Forum Discussion
Microsoft Teams Integration with Power BI Dynamic URL Filtering for Dashboard Based on Phone Number
- 1 year ago
You would have to generate the URL in Teams. And you would need to use a standard format like +16061258722 to disambiguate.
Hi lbendlin
Thank you for your prompt response. I understand report filter do not supports wildcards but I am more interested to know how to configur Power BI with Microsoft team's on my usecase:
The customer dashboard which contains customer phone number and their purchase deatils,
When I receive a call from a customer via Microsoft Teams, I want the customer dahboard Automatically generate the dymnamic URL to filter the data based on the customer phone number.
For Example: if I receive a call from the phone number '6061258722', I would like the customer dashboard to automatically generate and navigate to the following URL:
https://app.powerbi.com/groups/me/reports/26d5425d-da53-4ab1-a7c1-d7509fed0dd9/a772bbf4995425b63827?filter=FamilyMembersTable/PhoneNumbers eq '6061258722'
This would allow immediate access to the customer’s purchase details during the call. Could you advise on how to configure this integration or direct me to resources or contacts that might help achieve this functionality?
Thank you!
You would have to generate the URL in Teams. And you would need to use a standard format like +16061258722 to disambiguate.