cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chiaracaspani Frequent Visitor
Frequent Visitor

Check generated SQL query

Hi all,

since when i import data in my power bi report i am able to specify a sql query in the advanced options, i would like to know if is it possible to do the opposite thing: to import a dataset from my database without specifying any query and after that extract the sql query that power bi is using.

I am asking this because my problem is: how can i be sure that the data in the visualizations are correct if i can't look at the query that is generated? How can i do that?

 

Thanks in advance,

Chiara

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Check generated SQL query

Hi @chiaracaspani,

 

There is a feature called View Native Query in desktop for us to check backend T-SQL query. See: Power BI – Checking Query Folding With View Native Query.

 

View Native Query.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Check generated SQL query

A quote from Tommy Boy comes to mind...something about a T-bone, a bull and a butcher?

 

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: Check generated SQL query

Hi @chiaracaspani,

 

There is a feature called View Native Query in desktop for us to check backend T-SQL query. See: Power BI – Checking Query Folding With View Native Query.

 

View Native Query.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Dreamer_Argento Frequent Visitor
Frequent Visitor

Re: Check generated SQL query

Does anybody know how to see entire SQL Statment generated by Power BI (including WHERE, JOIN, GROUP BY ...).

Some answers of this post explain how to see the standard SQL Statment (select field1, field2 ... from table) but not includes relationships between tables, grouping, ...

Thank you for your attention to this matter.

 

 

Pavithra Frequent Visitor
Frequent Visitor

Re: Check generated SQL query

Hi,

 

Is there a way we could see the query for a visual/report created (with the joins and filters)?

 

Thanks,

Pavithra

Anonymous
Not applicable

Re: Check generated SQL query

I would like to see this as well!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)