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... how to get data in Pow...

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

Answered

how to get data in PowerBI?

(0) Share

Report

Report

Posted on by benovic

350

Hi all,

i am trying to create better reports using PowerBi with Dynamics 365 Business Central.

I notice that not all Data is available using the PowerBI Connector.

Is there a way, to get to data not offered in the connector?

Specifically, i want to have the Item Attribute tables in powerBI, to filter purchase lines by attribute

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,696 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

You need to create query objects, using vs-code, then publish them as web services, then the PBI-connector will see them and can import the data.

Here are some examples:

thinkaboutit.be/.../

Here's a video:

thinkaboutit.be/.../

Greetings,

Steven

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,024 Super User 2026 Season 1

#2

YUN ZHU 1,145 Super User 2026 Season 1

#3

Khushbu Rajvi. 705 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans