Hey everyone, One of my frustrations with the new API is that it did not include RLS capabilities that were present in the old 1.x version. I noticed that the API has been updated to 2.0.2 and ...
We have a pro licence, we have both Premium and a specific Embedded Capacity and have used the example shown to try and provide via our own portal reports to our suppliers. We have a pro account for the API call, which has admin access, all the tokens are coming back. We want to essentially say supplier A has logged onto the portal, they click on the report section, the API the uses the default user login, within the call it says Supplier ID = XXXX pull back just that supplier code/s and show this data to supplier A. If supplier B logs in they will only then see their associated code YYYY.
I have created the role "supplier", in the DAX i have done: [Supplier Id] = username()
When our platform team tries the API call they get this error:
Is there something i or they are missing, thanks for your help in advance 🙂
Encase this useful: Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 503. PowerBIErrorCode: OpenConnectionError OpenConnectionError: Failed to open the MSOLAP connection.