Forum Discussion
Integrate Dynamics 365
how to integrate existing Microsoft Dynamic 365 - Business Central reports with Power BI?
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.
9 Replies
Just a heads-up: when pulling data from Dynamics 365, watch out for complex entity relationships and permissions. I’ve used Skyvia to handle syncing and transformations before feeding into Power BI - helps avoid surprises later.
Hi powerbiexpert22 ,
To integrate Dynamics 365 F&O with Microsoft Fabric, here’s what worked for others:
- Enable SQL row version tracking on the source tables.
- Create indexes on the AX DB tables.
- Rebuild the solution in Visual Studio (this can take a few hours).
- 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
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?
If you're trying to view existing reports from Dynamics 365 Business Central in Power BI, here are a few ways to do it:
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.
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
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 AIHi burakkaragoz ,
is there any documenation available for second approach you mentioned , I am not clear on how to do it?
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.
