Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
im using Power BI to create template apps for my customers.
My reports are consuming the data exposed through my public API, and the url itself contains a unique id belonging to the account for which i want to retrieve the data for.
So let's say,
- customer 1 account id =123
- customer 2 account id = 345.
So, if customer1 will call url is /v1/customer/123/mydata to get his data
while customer 2 will have to call /v1/customer/345/mydata.
Now, my app is sharing the same reports/dashboards, but each customer will have to set his account id at startup in order to get his data. Is there a customer friendly way to achieve that (through a pop up at startup, or a field to fill in within the report) ?
Thanks in advance
AA
@Anonymous ,
The URL filter query may meet your requirement, please refer to:
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
thanks for your reply.
But i don't need to use odata to "filter" the data. I need to "inject" the account key within the url.
And odata syntax goes at the end of the url (ex.: api-url/endpoint?$filter=AccountName eq 'value')
While my accountId is within the URL (ex.: api-url/{account_id}/endpoint)
@Anonymous ,
I'm afraid currently custom URL is not supported. As a workaround, I would suggest you to add in user account column and configure dynamic RLS, you may refer to this blog: http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.