RE: Unable to connect Power BI to Business Central on-prem using basic auth
hi
The error message you are seeing when trying to connect Power BI to Business Central using basic authentication is related to security settings in Power BI. By default, Power BI requires that all credentials used for data source connections be encrypted.
However, when using basic authentication with Business Central on-premises, the password is sent as plain text and is not encrypted. This can cause Power BI to display the error message you are seeing.
To resolve this issue, you can disable the encryption requirement for the data source connection in Power BI. Here are the steps:
Open Power BI Desktop.
Go to 'File' > 'Options and settings' > 'Data source settings'.
Find the data source you are trying to connect to Business Central on-premises and click on 'Edit Permissions'.
In the 'Edit Permissions' dialog, uncheck the 'Encrypt connections' option.
Click 'OK' to save the changes and close the dialog.
Test the data source connection again.
Note that disabling encryption for data source connections can have security implications. If possible, it is recommended to use a more secure authentication method, such as OAuth, when connecting to Business Central on-premises.
DAniele