Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MayuraPara
New Member

Business Central Data in Power BI

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,

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

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

vyiruanmsft_0-1691041144097.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.