Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ADF to Power BI

Hi Guys!

 

I'm new using the ADF I tried connecting it to Power BI using REST since I need to get some logs.

I tried the documentation below:

https://docs.microsoft.com/en-us/power-bi/admin/read-only-apis-service-principal-authentication

 

I'm having error when running it:
Failure happened on 'Source' side. ErrorCode=RestSourceCallFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The HttpStatusCode 404 indicates failure. Request URL: https://api.powerbi.com/v1.0/myorg/admin/ Response payload:,Source=Microsoft.DataTransfer.ClientLibrary,'

 

Just want to know if I'm doing it correctly:

  1. Create App 
  2. Create New Security group
  3. Add the App on teh Security group
  4. On the Allow Service Principal on the Power BI add the Security Group
  5. Add the App as a contributor on the IAM of the ADF
  6. Rest Linked Services

       

7. Copy Activity on the Pipeline

 

Advance thanks!

 

 

           

 

Need Help

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    4 years ago

    Hi. I think you are missing allowing service principal in PBI admin portal, not just to the admin API but for the whole service. You can also try adding permissions to the App registered for PBI Service or grant Admin concent to all permission (only an admin can do that). You can follow this post (that is preparing ADF to refresh and not using the admin) to check if you are missing something.
    https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-con

    You can also try the requests writing code to know if the Service Principal is working and it's an ADF issue or if it's not and the problem is the configuration.

    I hope that helps,