Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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,
User | Count |
---|---|
47 | |
27 | |
21 | |
19 | |
19 |
User | Count |
---|---|
53 | |
47 | |
24 | |
20 | |
19 |