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.

     

     

     

burakkaragoz's avatar
burakkaragoz
Super User
1 year ago

Hi powerbiexpert22 ,

 

To integrate Dynamics 365 F&O with Microsoft Fabric, here’s what worked for others:

  1. Enable SQL row version tracking on the source tables.
  2. Create indexes on the AX DB tables.
  3. Rebuild the solution in Visual Studio (this can take a few hours).
  4. Use Link to Fabric from Dataverse and select the required tables.

Keep in mind:

  • Virtual tables from Dataverse won’t sync directly – you may need to convert them to physical tables.
  • Make sure your Dataverse environment and Fabric workspace are in the same region.
  • Only one D365 environment can be linked to a single Lakehouse.
    translation and formatting supported by AI