How to Connect Business Central and Power BI

[@charlesallen4821]

Very good demo. There's one question for which I'm having a hard time finding an answer. When you build a report in Power BI and publish it, you need to set up a data connection to BC so you can refresh the report. When you go to create a connection, one of the options is API Category. If you're using the legacy option, what do you enter in this field? This is in the Gateway Connection which I presume you need to set up but I may be wrong.

[@theacademyhub]

@charlesallen4821 - We continue to update the integration between Business Central and Power BI. Originally, we relied on OData. If you want to dig deeper on the connections I would recommend you explore the docs.microsoft.com entry. Here is the link - learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup.

[@richardtang292]

I have encountered the issue : You need to use SSL (HTTPS) when you use OAuth 2.0 authentication. What should I do?

[@theacademyhub]

Hi Richard! I recommend retrieving an SSL certificate, installing it on your server, and updating your URLs to use