Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SQL Query behind report !

Hi   I have a report which is based on 4 tables/views which are linked in a model relationship.   The report was written by someone else who has left.   I am a SQL guy and I cant work out how t...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    There is no single query that represents the model.  The data you see presented in the visuals is a mix of the tables in Power Query and the Columns and Measures created in Power Pivot (Data View).

    You are asking to see a combined SQL query - even if all the data is loaded from a SQL database there are still transformations made in Power Query and other modelling happening in Power Pivot/DAX that are not part of any SQL command.

    Regards

    Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks but I dont think I am explaining myself correctly. Yes if I go into power query I can see the 4 tables and views but I cant see the full query that represents the model when all the tables/views are joined together. If I try to simulate the sql query for the model using 3 joins the data does not match what powerbi shows so I just want to see what the combined sql query is that gives me the result in a visual bases of course whatever filters have been applied..

 

does that make sense.. thanks

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    There is no single query that represents the model.  The data you see presented in the visuals is a mix of the tables in Power Query and the Columns and Measures created in Power Pivot (Data View).

    You are asking to see a combined SQL query - even if all the data is loaded from a SQL database there are still transformations made in Power Query and other modelling happening in Power Pivot/DAX that are not part of any SQL command.

    Regards

    Phil