Business Central Data in Power BI

Anonymous

Not applicable

3 years ago

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