Forum Discussion

MOHANSAIV's avatar
MOHANSAIV
Microsoft Employee
1 year ago

Power BI Dataset Refresh via ADF → Logic Apps

I am trying to refresh a Power BI dataset (single table and single partition) using an ADF pipeline triggered through Logic Apps.

Previously, I had implemented a similar approach to refresh Analysis Services datasets, and it used to work fine. However, while attempting the same with Power BI data model, I am now facing the following issue.

Could you please help me in resolving this issue and advise if there are any specific tenant settings or admin configurations required to allow service principals for dataset refresh?

And also provide me with the POC who can help us in enabling the SPN in Power BI Tenant Settings?
Workspace Url: Power BI

Error:
{
"X-PowerBI-Error-Info": "ServicePrincipalIsNotAllowedByTenantAdminSwitch",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "deny",
"X-Content-Type-Options": "nosniff",
"Access-Control-Expose-Headers": "RequestId,X-PowerBI-Error-Info",
"request-redirected": "true",
"home-cluster-uri": "https://df-msit-scus-redirect.analysis.windows.net/",
"RequestId": "6d1e568c-15ec-46f7-9635-e488fd45cfe0",
"Date": "Mon, 18 Aug 2025 06:48:06 GMT",
"Content-Length": "0"
}

Need Help

5 Replies

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi MOHANSAIV ,

    In addition to the points already shared by the jaineshp , please also review the following.

    1. The service principal needs either a Power BI Pro license, or the dataset must be in a Premium/PPU workspace. Without this, the refresh will still fail even if the tenant setting is enabled.

    2. Make sure the service principal has at least Member or Contributor access in the Power BI workspace. A Viewer role won’t allow dataset refresh operations.

     

    Let me know if you’d like more details happy to assist further.

     

    Thanks again for your quick response, jaineshp .

     

    Regards,
    Yugandhar.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi MOHANSAIV ,
    Please let us know if you are facing any issues so that we will take a look into it and address ASAP.

    Thank You.

     

    • MOHANSAIV's avatar
      MOHANSAIV
      Microsoft Employee
      1 year ago

      Appreciate your follow up.

      I am working with the Power BI front desk team to allow the SPN in the PBI Workspace. Once they enable the SPN, I will retry and share the response. 

      Thank You!!

      • V-yubandi-msft's avatar
        V-yubandi-msft
        Community Support
        1 year ago

        Hi MOHANSAIV ,

        If there’s any update from the Power BI front desk team, kindly share it here. It’ll be helpful for other community members who might be facing similar issues.

        Thanks for your support.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Have you received any updates from the Power BI Front Desk team. If so, could you please share them with us.

     

    Thank you.