There is a new data connector available in that you can use to build reports for Dynamics 365 Business Central. When you have Power BI desktop opened, navigate to:
- Get Data
- Online Services’ > ‘MS Dynamics 365 Business Central
- Drill down into the companies to connect directly. your published Web Services to build reports in Dynamics 365 Business Central
Since Data connection is using AAD authentication, Web Services, any reports that you create can be saved to the website and shared with other users in MS Dynamics Business Central
The Power BI dashboard relies on the published web services that are listed above, and it will show data from the demonstration company or your own company if you import data from your current finance solution. However, if something goes wrong, this section provides a workaround for the most topical issues.
- Incorrect Company Name
A common mistake is to enter the company display name instead of the company name. To find the company name search for Companies. Then use the Name field when entering your company name.
- Incorrect User Name and Password
The user name and password used to connect will be the same as what is used to connect to your Microsoft Office 365 account.
The content packs also require that you have a Microsoft Dynamics 365 Business Central account. Once you enter your credentials, we will auto-discover any Microsoft Dynamics 365 Business Central tenants you have access to. If you do not have a licensed or trial Microsoft Dynamics 365 Business Central account, you will receive an error message.
- The Key Didn’t Match Any Rows in the Table
If you enter a non-valid company name during the connection process, you may get the error message “The key didn’t match any rows in the table”. Provide the correct company name and try connecting again.