Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Investigating

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


    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/