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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,161 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,970 Super User 2026 Season 1 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No