Seeing the query data behind the filters

[MEFOX]

I have a visual that is displaying a count greater than I'm expecting the value to be. The value is based on a join between several queries in the report. The queires do not have any SQl behind them. The queries are a straight pull from the database tables. Is there a method in PBI desktop that I can see all the joined query data before the report Filters narrow the results? I'm using Import mode.

Thanks

[AlexisOlson · Accepted solution]

You can use the Performance Analyzer to capture the DAX queries behind the calculations.

See here too: https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

[MEFOX]

I'm restating my question to see if I can make it clearer. The developer of the PBI reports did not build any SQL queries in the reports. Instead he created numerous relationships between SQL tables. He then used report filters in an attempt to get down to the results he needed in the reports. The problem I'm discovering is that some of the numbers displayed in the report are incorrect. Becasue I can't extract the data behind the filters I don't know what the data is before the filters were applied. Is there a method to extract the data from the results created by the manage relationships? 

[AlexisOlson]

Capture the DAX queries and remove the filters applied in the query to get an unfiltered version of the query.

[MEFOX]

How do I capture the DAX queries?

[AlexisOlson]

That's explained in the linked articles in my first reply.