Multiple tables and combine to make a data entity

(0) Share

Report

Posted on by Bibin TV

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

2273.pastedimage1666777380799v3.png

Error message

4174.pastedimage1666776930013v1.png

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 237,961 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bibin TV 45 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,961 Most Valuable Professional on at

Like (0)

Report

Yes, union queries are supported and you can use the same table several times in the same query (with different data source names).

Was this reply helpful? Yes No
Bibin TV 45 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,961 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No