Dynamics 365 Business Central data connector in Power BI

There is a new connector available in Power BI desktop 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' > 'Microsoft Dynamics 365 Business Central'

As long as you are signed in with a user that has access to Business Central it should automatically load up a list of your existing companies.  You can drill down into the companies to connect directly to your published Web Services to build reports.

Since this connector is using AAD authentication, any reports that you create can be saved to the Power BI website and shared with other users.

You must have the latest version of Power BI desktop (April 2018) for the new connector to show up.
Learn more about Power BI

Comments

• Anonymous
  May 21, 2018
  Hi, can you please describe more in details how this connector works and if there are other options?For example, is this connector using OData or directly towards Azure SQL (ODBSC or DirectQuery)? If we want, is it possible to copy the SQL database to a "BYOD" or Data Warehouse similar to how D365FO does it?
  • Anonymous
    May 21, 2018
    I believe it is using the OData connection, which is why you must have the Web Service published for it to show up. There aren't any options for copying your data to a BYOD or Data Warehouse similar to Finance and Operations at this time.