Business Central Data in Power BI

[MayuraPara]

I need to build a dashboards in Power Bi using the Business Central data. I can connect to Business Central data from Power BI. However, I am concerned about extracting large volumes of data via API from Power BI? Has anyone experienced any issues? Should I implement  a datawarehouse? However, there aren't any connectors for Business Central in Azure data factory. There is OData connector, but having issues.

Any suggestions or advice will be mjuch appreciated.

Thanks,

[Anonymous]

Hi @MayuraPara ,

To connect to Business Central in Azure Data Factory, you need to create a linked service that specifies the connection information and credentials. You can use the OData connector to connect to Business Central. You also need to configure an integration runtime that can access the Business Central endpoint. In Power BI Desktop, you can use the Azure Analysis Services connector to connect to the Azure Data Factory service. You need to provide the server name, database name, and authentication type. You can then import or query the data from the Azure Data Factory service.

Create linked service: 

Create linked service

Integration runtime:

Data factory integration runtime requirements

Data factory configure integration runtime

Using Azure Analysis Services connector:

analysis-services-connect-pbi

Best Regards