MFA authentication using business central api

[JohnF5343]

Hi,

We are currently refreshing business central api data with a standard user account. This account will be enabled for MFA authentication in the next weeks and we were wondering what the best practice is. 

Can we create a service account or can we use an app to refresh the data in the power bi service?  Can PowerBI use Client/App ID and Client Secret to autheticate on business central?

Thanks for any help.

[v-yanjiang-msft]

Hi @JohnF5343 ,

Here're detailed steps for your reference: Configure Business Central for Excel and Power BI  | Microsoft Docs

 Configure Business Central content packs in Power BI - Learn | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

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

[GilbertQ]

Hi @JohnF5343 

You would need to ask the business central people who look after the API if you can use a Client/AppID to use to authenticate with business central.

It is certainly true that you cannot use an account with MFA because when it is automated there is no option to enter the MFA.

[JohnF5343]

Thank you. They have created an app for me but I'm unsure how to proceed, how do I enter these details in the power bi desktop? Thanks.