Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

Integrate Dynamics 365

how to integrate existing Microsoft Dynamic 365 - Business Central reports with Power BI?
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi powerbiexpert22 

     

    I dont think it is possible to view BC reports inside Power BI. I worked on a project that used BC and we had to re-create the reports in Power BI by using the BC Connector. Alternatively, there are built-in BC Power BI apps you can try.

     

     

     

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago

Hi burakkaragoz ,

the requirement is we have some Microsoft Dynamic 365 - Business Central reports which we want to view on  Power BI . how to acheive this?

  • burakkaragoz's avatar
    burakkaragoz
    Super User
    1 year ago

    If you're trying to view existing reports from Dynamics 365 Business Central in Power BI, here are a few ways to do it:

    1. Use the built-in Power BI connector:

      • In Power BI Desktop, go to Get Data > Online Services > Dynamics 365 Business Central.
      • Sign in with your credentials and select the environment and company.
      • You’ll see a list of available tables and reports you can load directly.

    2. Publish Business Central reports to Power BI:

      • In Business Central, go to the report or page you want.
      • Use the "Open in Excel" or "Analyze in Excel" feature, or export the data and build a Power BI report on top of it.
        translation and formatting supported by AI

    3. Use APIs or OData feeds:

      • Business Central exposes data via OData endpoints.
      • You can connect to them using Get Data > OData Feed in Power BI.

    Let me know if you're trying to embed existing RDLC reports or if you're working with custom extensions – the approach might change slightly.
    translation and formatting supported by AI