Apr 19 2024 11:05 AM
Hi,
I am encountering issues executing the GET command to retrieve data model role assignments using PowerBI REST API (version 2.0) through Azure Data Factory. I aim to automate this process within our workflows.
Is this even possible to implement any GET command using PowerBI REST API version 2.0 in Azure data factory? For context, similar commands under version 1.0 work seamlessly.
Thank you!
P.S. Added documentation op Rest API (API version 2.0)
Apr 21 2024 11:41 PM - edited Apr 21 2024 11:41 PM
@ricardofarmer In your example, you reference the Power BI Report Server REST API. This is different from the general Power BI REST API.
https://learn.microsoft.com/en-us/power-bi/report-server/rest-api
https://learn.microsoft.com/en-us/rest/api/power-bi/
The PBI Report Server is an on-premise service, so the service endpoint is different from the Power BI cloud endpoint. You should also check the firewall rules of your on-premise network in which your Report Server is hosted.
So it's not about two different API versions but two entirely different REST APIs.
Apr 22 2024 01:27 PM
Apr 22 2024 11:54 PM - edited Apr 22 2024 11:54 PM
@ricardofarmer you might be able to use the Admin API to achieve your goal.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-report-users-as-admin
Make sure you have enabled the admin API and your service principal has sufficient permissions.