Power BI XMLA refresh single table through Logic App

[Anonymous]

Hi,

I am trying to use logic app to refresh one of the table in my power bi dataset but it is giving me erorr 404 not found.

I have service principal created and api permission is also given to read.write analysis services models.

I also have configured my premium capacity to have XMLA read write option.

I am able to connect to the default connector logic app has to refresh the power bi dataset and refresh the dataset.

I am trying to refresh single table in the model and by using HTTP activity in logic app. I am not able to figure out what is the problem as there is not much information in the error as well. BTW I am able to connect to the same url through management studio analysis services and process tables manually.

my base uri when  using management studio is  powerbi://api.powerbi.com/v1.0/myorg/Work%20space%20Name

URI when using logic app is httpsi://api.powerbi.com/v1.0/myorg/Work%20space%20Name

Authentication type : Active Directory OAuth

tenant id

application ID

seceret 

value

 all values has been provided

[skylinesh]

@Anonymous Can you tell that how you implemented the detail in HTTP activity and how you schedule it to run? Thank you so much.

[Anonymous]

Hi @Anonymous 

Do you want to refresh dataset in Workspace by Rest API? And your authentation method is Service Principal.

You can have a test by "Try it" from this link.

For reference: Datasets - Refresh Dataset In Group

If you can succeed to refresh your dataset in "Try it", there may be something wrong in your authentation.

Try to get access token by Service Principal in Postman. Note : Grant_Type should be client_credentials instead of Password due to you use Service Principal.  Resource should be "https://analysis.windows.net/powerbi/api".

For reference: Power BI REST API using postman - generate embed token.

Please check the step of your service principal configuration.

For reference: Method

Pleasec check whether you enable the Power BI Service admin setting and add the security group into it.

Pleasec check whether you add this service principal into the workspace contain the dataset you refresh.

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.

[Anonymous]

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

[Anonymous · Accepted solution]

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.