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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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