Announcements
No record found.
Hi Team,
Appreciate someone can assist on the below queries.
I am beginner in D365 development. Now there is a requirement to collect the data from multiple tables and combine (by join, union) to make a data entity to build Power Bi report.
I am getting the below error while building the solution. Kindly assist.
Query Design
Error message
Moved from Dynamics 365 General Forum because it seems to be about F&O.
The problem is that your query has multiple root queries. You should have just one, and add joined data sources to its (nested) Data Sources node.
Thank you for the quick reply, is there a way can make union with same table as below. kindly advise the best way to achieve this.
Sample in SQL
Yes, union queries are supported and you can use the same table several times in the same query (with different data source names).
Sorry Martin, Still I'm not clear with this solution. Kindly help.
Step-1(Query made with different data sets by referring same table)
Step-2(To create view with the Query (GFNProductCategoryGroupingQuery) there I'm stuck.
Just saying that you created a query or a view is insufficient. There is a lot of important configuration. Mosty importantly, if you want a union query, you need to set its Query Type to Union.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 455 Super User 2026 Season 1
Syed Haris Shah 308 Super User 2026 Season 1
