Power BI Table Details

(0) Share

Report

Posted on by swenger

150

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)

Suggested answer

swenger 150 on at

Like (1)

Report

RE: Power BI Table Details

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

YUN ZHU 73,333 Super User 2024 Season 2 on at

Like (0)

Report

RE: Power BI Table Details

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

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Power BI Table Details

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.
swenger 150 on at

Like (0)

Report

RE: Power BI Table Details

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

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Power BI Table Details

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