Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've following model defined in my Power BI Desktop
PRODUCT -------------> PARTY_PRODUCT <--------------- PARTY
1 to Many (Single) 1 to Many (Single)
If I make a report adding 'prouct name' from PRODUCT and COUNT(PARTY_ID) from 'PARTY', it makes a cross join and shows following date
PRODUCT_NAME COUNT(PARTY_ID)
A 100
B 100
C 100
D 100
E 100
F 100
To identify the issue, i need to see what query does POWER BI SERVICE make. how can i view the final query?
I looked into DB (Azure Warehouse) query (using select * from sys.dm_pdw_exec_requests) which makes two seperate query and then stitches them in POWER BI.
Is it possible to see final query made by SERVICE in POWER BI?
Thanks.
Solved! Go to Solution.
No. It's still not supported to see the query generated by Power BI. You may submit a feature request on idea.
Regards,
I haven't encountered your issue. Please verify your relationship built. See my sample with a similar many-to-many scenario as yours:
Regards,
Simon Hou
@v-sihou-msft, yeah I got it. I changed my cross filteration to both and it worked perfectly.
But is there any way I can look at the query that Power BI made? just like 'Query View' in Microstrategy?
Thanks.
No. It's still not supported to see the query generated by Power BI. You may submit a feature request on idea.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.