web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Connecting Sales Data ...

Small and medium business | Business Central, N...

Suggested Answer

Connecting Sales Data to Power BI

(0) Share

Report

Report

Posted on by HzJ

60

Dear Champions,

I want to connect Business Central (Dynamics 365) data with Power BI to generate reports which are not directly available in Business Central.

I need the Sales Table (item wise and invoice wise) in Power BI to customize report.

Can anyone guide on how this connection can be done in my POWER BI account?

Huzefa Rasheed

Dubai

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,698 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sure.

First you need to develop an extension that exposes some queries as web services. These queries you can create based upon the tables you want to expose.

Then, once the extension is published on your tenant, you simply import the data in PBI Desktop and create your report.

Here are some resources:

docs.microsoft.com/.../

https://youtu.be/g_eWPPi8Aiw

https://youtu.be/ZBDugiBZXDU

www.youtube.com/results

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 580 Super User 2026 Season 1

#2

YUN ZHU 480 Super User 2026 Season 1

#3

Grigorios Mavrogeorgis 261 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans