Forum Discussion
How to programmatically assign permissions to a Power BI dataset model for accessing an ADX cluster?
Given:
- I have a Power BI report using Azure Data Explorer (ADX) as a data source.
- I'm implementing "multitenancy apps in Power BI Embedded" as described here: https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy#prerequisites
- I use Power BI REST APIs.
I successfully followed the steps to create profiles, workspaces, and import reports programmatically. However, my report cannot access the ADX cluster. I can enable access manually through the Power BI web app UI using my account's OAuth2 permissions, but I need to do the same programmatically via REST.
I cannot find any documentation or Power BI REST APIs to achieve this.
I've found this as an answer
https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource
3 Replies
- GilbertQ
Super User
Hi vitaliymaz
I had a look in as far as I can see, it is not possible to do this via a power BI rest API. My only other suggestion is to create a single semantic model and then use Row Level security to determine who can see what
HI,vitaliymaz
Can you tell me if your problem is solved? If yes, please accept it as solution.
Best Regards,
Leroy Lu
I've found this as an answer
https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource
