Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

404 Error in ADF while trying to fetch data from Power BI APIs

Hi Everyone,

 

I created an Synapse pipeline to extract the user activity from the Power BI API. I set it up as follows:

  1. Creating an Azure Security Group 
  2. Added the Azure DataFactory as a member to that security group
  3. Adding the security group to the Power BI Admin portal 'Allow service principals to user Power BI API's'
  4. Created a linked server in the ADF
    MakarandZende_0-1693246996803.png


    But I keep getting the error message as below:

    Rest call failed with client error, status code 404 NotFound, please check your activity settings.
    Request URL: https://api.powerbi.com/v1.0/myorg/admin/.
    Response:

    I have even referred to some posts with similar implementation as below but still no luck:
    https://justb.dk/blog/2021/02/extracting-the-power-bi-activity-log-with-data-factory/
    https://www.phdata.io/blog/how-to-get-activity-data-from-power-bi-service-with-rest-apis/

Status: Investigating

Hi  @Anonymous 

I found a similar case , hope it can help you !

403 error on API through ADF - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi  @Anonymous 

I found a similar case , hope it can help you !

403 error on API through ADF - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao