when i am trying to connect with username and password (web service access key) it shows me error " the password wont be encrypted when sent"
Hi, hope the following helps as well.
Set up Business Central on-premises for Power BI integration
https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup#setup
Thanks.
ZHU
Hello,
You are not able to connect over http to a PowerBi source. It must be at least a trusted SSL cert en ODataV4 and SSL must be enabled on the NST instance.
Thank you.
Hi Daniel,
Thanks for reply . I follow the steps but not able to find Encrypt Connection Option.
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
André Arnaud de Cal...
294,163
Super User 2025 Season 1
Martin Dráb
232,960
Most Valuable Professional
nmaenpaa
101,158
Moderator