Forum Discussion

abdul_rehman's avatar
abdul_rehman
Frequent Visitor
9 years ago
Solved

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.

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

4 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    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:

     

     

     

    Regards,

    Simon Hou

    • abdul_rehman's avatar
      abdul_rehman
      Frequent Visitor

      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's avatar
        v-sihou-msft
        Microsoft Employee

        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,