Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
abdul_rehman
Frequent Visitor

View Query made by Power BI

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.

1 ACCEPTED SOLUTION

@abdul_rehman

 

No. It's still not supported to see the query generated by Power BI. You may submit a feature request on idea.

 

Regards,

View solution in original post

4 REPLIES 4
v-sihou-msft
Microsoft Employee
Microsoft Employee

@abdul_rehman

 

I haven't encountered your issue. Please verify your relationship built. See my sample with a similar many-to-many scenario as yours:

 

34.PNG

 

33.PNG

 

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.

@abdul_rehman

 

No. It's still not supported to see the query generated by Power BI. You may submit a feature request on idea.

 

Regards,

Thanks a lot @v-sihou-msft

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.