View Query made by Power BI

[abdul_rehman]

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.

[v-sihou-msft]

@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:

Regards,

Simon Hou

[abdul_rehman]

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

[v-sihou-msft · 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,

[abdul_rehman]

Thanks a lot @v-sihou-msft