Forum Discussion

piper's avatar
piper
Frequent Visitor
6 years ago
Solved

Disabling multi factor authentication for power bi

Hi All,   I am new to power BI, and have purchased power bi pro account for some POC. However, a multi-factor authentication got enabled when I registered my cell/phone number with Azure/PowerBI. ...
Need Help
piper's avatar
piper
Frequent Visitor
6 years ago

Thanks nickyvv for your response.

 

Currently, for every new client, we are creating new workspace/group via REST apis. This is required to clone reports to entirely new workspace dedicated for a client.

There are few limitations for using service principal, which are provided on same link which you have shared, like following one:

 

"Embed for your organization applications can't use service principal."

 

I am not sure, but with this, I think I won't be able to generate embed token for reports.

 

I had tried service principal approach in past for powerbi rest api, before going for powerBi pro, and it hadn't work earlier.

I will try it again, and update back.

 

Meanwhile, do you think if there is any way to either disable MFA or get access token silently with MFA?

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi piper ,

 

The request requires the user to do multi-factor authentication and then send this new token back to Web API 1 and complete the on-behalf-of flow. MFA was enabled by triggering a rule if some action (e.g. sudden location change) was treated as "risky activity". For an account there is a "moved to a new location" flag that can get set, automatically triggering the need for MFA, even if it was initially off.

 

Please check the conditional access locations in Azure AD and check if your AAD admin can clear the flag. Disable MFA for the account or configure conditional access to give access to "Global Admin" role.

 

Please find additional info in the following articles:

https://docs.microsoft.com/en-us/azure/active-directory/active-directory-conditional-access-locations

https://docs.microsoft.com/en-us/azure/active-directory/develop/conditional-access-dev-guide

https://docs.microsoft.com/en-us/office365/admin/security-and-compliance/set-up-multi-factor-authentication?view=o365-worldwide

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

  • piper's avatar
    piper
    Frequent Visitor
    6 years ago

    Thanks v-deddai1-msft .

     

    I have followed steps outlined here :https://docs.microsoft.com/en-us/microsoft-365/admin/security-and-compliance/set-up-multi-factor-authentication?view=o365-worldwide#manage-security-defaults

     

    And, have disabled default security measures. I understand this is bit risky as per security, but it has unblocked me for now.

    I was able to get access token for powerbi rest api.

     

    Once POC completes, I will go through shared links in detail, to setup conditional access.

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      6 years ago

      Hi piper ,

       

      If my post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai

    • KarlOnEarth's avatar
      KarlOnEarth
      Frequent Visitor
      6 years ago

      G'day piper ,

      Did you ever 

      piper wrote:

      ... go through shared links in detail, to setup conditional access.

      I am facing the issue of MFA, I turned on MFA for the accont that I use to refresh data and now my refreshes are failing. From the documentation v-deddai1-msft quoted here: 

      https://docs.microsoft.com/en-us/azure/active-directory/active-directory-conditional-access-location...

      it appears one will need to specify a range of IP addresses for the Power BI service servers. Is that what you did?

      • KarlOnEarth's avatar
        KarlOnEarth
        Frequent Visitor
        6 years ago

        Actually I think I have solved it for my installation. It may have been that I just had to re-send my SharePoint credentials in the Power BI admin console. I had been into the AD conditional policy and specifically Excluded the Power BI Service but it was still failing. After a while I noticed a message in the Power BI Datasets area that some credentials needed to be updated; the ones for SharePoint data source. I re-entered those and it sprang back into life for me, I am now doing scheduled refreshes again with MFA turned on.