Power BI Table Details

(0) Share

Report

Posted on by swenger

172

I am trying to build a table to show all the detail line of sales order. But it only shows item number once. If the same item is used on multiple lines of the same sales order it only displays 1 line. It is like a summary Query but i want to see the multiple lines even if it duplicates this field. Is there a way to do this?

Thanks

Sam

All responses (5)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

What are you using as the datasource for your Power BI report?

Please look at this thread for a good way to get your order data from Business Central to Power BI

community.dynamics.com/.../1328006
swenger 172 on at

Like (0)

Report
Copy link

Link copied!

I started the previous thread that you are referencing. I am using the salesDocuimentLines as suggested from that post but the issue is that it won't display duplicate lines for the same part number.
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry. I did not notice that.

Did you do any grouping i your report?

Or is the data grouped even when you preview the data source?

I justed cecked when i use the data source i suggested I get the data line by line. So my guess is that the grouping is in your report.
Suggested answer

YUN ZHU 103,227 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, I tested it, and it seems that there is no such problem. Please check your Power BI settings.

Hope this helps.

Thanks.

ZHU
Suggested answer

swenger 172 on at

Like (1)

Report
Copy link

Link copied!

I found the problem. The default was "Summarized" so i changed it to "Don't summarize" and it worked.