cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GraceTCL
Helper II
Helper II

View Native Query always disabled

Hi

 

Why is the View Native Query option always grayed out / disabled in Power Query?  I use SQL Server Database and tested with simple queries.  Zero transformations, filters, field name aliases, etc...  No matter what, I have never been able to View Native Query.  It's always disabled.  

 

This is even if I disable "include relationship columns" check box and specify the timeperiods to import the data.

1 ACCEPTED SOLUTION
edhans
Super User III
Super User III

Are you putting any queries in the Advanced dialog box?

edhans_0-1619827066507.png

No folding will happen, and the View Native Query will be grayed out. Leave that box blank, connect directly to the table or view, then do further transformations in Power Query itself. Some things will fold, some won't. That is a much larger thread.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
edhans
Super User III
Super User III

Are you putting any queries in the Advanced dialog box?

edhans_0-1619827066507.png

No folding will happen, and the View Native Query will be grayed out. Leave that box blank, connect directly to the table or view, then do further transformations in Power Query itself. Some things will fold, some won't. That is a much larger thread.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

watkinnc
Solution Sage
Solution Sage

Could we have a look at the query?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors