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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
