Power BI Connector for ServiceNow
Breadcrumbs

How to Connect to Power BI if ServiceNow Uses MFA/2FA/SSO

➡️ Explanation: Microsoft Power BI doesn’t support two-factor authentication. If your organization uses MFA, 2FA, or SSO, you might have troubles connecting to Power BI with the Basic authentication method.


Microsoft Power BI - Error.gif


➡️ Solution: To address this issue you can:

  • Create a service account with a local password: Ask your ServiceNow admin to create a separate service account without MFA and set a local password for it so can use it for further Power BI authorization.

3c8ba443-604f-4751-aba0-3ba104dc0d41#media-blob-url=true&id=7e3b6858-6282-4623-8f41-f5e0054f959c&contextId=20840&collection=
  • Use Blank Query Connection: Utilize the new Blank Query Connection method without disabling SSO.

Read more about Blank Query Connection.