Business central connection

[Jhamed]

Greetings,
I am trying to connect to business central finance app but it is not working.  Does anyone have any suggestions.

Any help is much appreciated.

[Anonymous]

Hi @Jhamed 

Here are several steps and suggestions that might help resolve the issue:

1. Check Permissions: Ensure that you have the necessary permissions in both Power BI and Dynamics 365 Business Central. You need to have access to the data you're trying to retrieve in Business Central, and also need the appropriate permissions in Power BI to import data.

2. Use the Right Connector: Make sure you're using the correct connector in Power BI for Dynamics 365 Business Central. Power BI provides a specific connector for Business Central. When you go to "Get Data" in Power BI, search for Dynamics 365 Business Central and select it.

3. Verify Your Account: Ensure that the account you're using to connect to Dynamics 365 Business Central from Power BI is correctly configured and has access to the Business Central environment.

4. Check the API Page: If you're using an API to connect, ensure that the API page is published in Business Central. Some data might require specific API pages to be exposed for Power BI to access them.

5. Update Your Services: Ensure that both Power BI and Dynamics 365 Business Central are up to date. Sometimes, connection issues can arise due to version mismatches or bugs that have been fixed in later updates.

6. Review the Error Message: If there's an error message, carefully review it for hints about what might be going wrong. It can often provide clues on whether it's a permission issue, a connection problem, or something else.

Best Regards,

Jayleny

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