MFA authentication using business central api

Question

Hi,&nbsp;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.&nbsp;&nbsp;Can we create a service account or can we use an app to refresh the data in the power bi service?&nbsp;&nbsp;Can PowerBI use Client/App ID and Client Secret to autheticate on business central?&nbsp;Thanks for any help.

gilbertq · Answer

Hi&nbsp;JohnF5343&nbsp;
&nbsp;
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.
&nbsp;
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.
&nbsp;
&nbsp;

johnf5343 · Answer

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.

v-yanjiang-msft · Answer

Hi&nbsp;JohnF5343&nbsp;,
Here're detailed steps for your reference:&nbsp;Configure Business Central for Excel and Power BI&nbsp; | Microsoft Docs
&nbsp;Configure Business Central content packs in Power BI - Learn | Microsoft Docs
&nbsp;
Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please considerAccept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

MFA authentication using business central api

3 Replies

Related content

CANNOT connect to Dynamics 365 Business Central

How to connect Business Central Financial Reports to Power BI

Setup Lakehouse with Business Central

Free BI Reports in Business Central

Load Large data from business central