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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (