Forum Discussion
Power BI XMLA refresh single table through Logic App
Hi Anonymous
I think you need to follow the steps in blog as below like adding your service principal into a security group and add this group as a member in API Permission in Power BI Service tenant setting.
For reference:
embedded/embed-service-principal#step-1---create-an-azure-ad-app
In my test I use Post https://login.microsoftonline.com/TenantID/oauth2/token .
And add grant_type(client_credentials) ,Resource( https://analysis.windows.net/powerbi/api) , client_id ,client_secret in request body.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thanks for the details. I tried to test with "Try it" and was able to refresh my dataset.
So I tried to the postman way but I see I am getting an below error. As suggested I gave given grant_type as client_credentials and then provided my client_secret. The POST url I used is "https://login.windows.net/common/oauth2/token" and resource as suggested by you.
I tried to read the "Method" link shared by you to understand the process. I am bit confused at the AD security point. does this mean I need to add the Service Principal APP to the AD security group ? what if I organization had enabled option "for entier organization" ? even in that case do I need to have a security grouo created and add this APP in that? can you please elobrate on this point a bit more please? I think the issue is authentication and it is struglling to get access. Once again thanks a lot for your details explanation
Hi Anonymous
I think you need to follow the steps in blog as below like adding your service principal into a security group and add this group as a member in API Permission in Power BI Service tenant setting.
For reference:
embedded/embed-service-principal#step-1---create-an-azure-ad-app
In my test I use Post https://login.microsoftonline.com/TenantID/oauth2/token .
And add grant_type(client_credentials) ,Resource( https://analysis.windows.net/powerbi/api) , client_id ,client_secret in request body.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.