Native query greyed out

[SMid]

Hi all,

I am trying to fold my queries, but the View Native Query option is always greyed out, even at source. I am only connecting to SQL server, and not using the SQL statement box in the advanced options as mentioned in this thread: https://community.powerbi.com/t5/Power-Query/View-Native-Query-always-disabled/td-p/1305544 . Still the View Native Query option remains greyed out. I'm not sure why this would be the case?

Don't know if it helps, but these are the steps shown in advanced editor:

let
Source = Sql.Database("server", "database"),
#"dbo_Strong DE$Customer Backconditions" = Source{[Schema="dbo",Item="Table"]}[Data]
in
#"dbo_Strong DE$Customer Backconditions"

Thanks!

Kind Regards,

Smid

[BA_Pete · Accepted solution]

Hi @SMid ,

Silly question, but have you checked that your Navigation step has a Native Query?

The source step will never have a Native Query as it doesn't form a complete SELECT statement, but you should have it from Navigation onwards.

Pete

[Fowmy · Accepted solution]

@SMid 

If you check on the Source Step, it always shows greyed out but query folds, check on the 2ns step where you navigate to a table

[SMid]

Doh, thanks to both of you.

[BA_Pete · Accepted solution]

Hi @SMid ,

Silly question, but have you checked that your Navigation step has a Native Query?

The source step will never have a Native Query as it doesn't form a complete SELECT statement, but you should have it from Navigation onwards.

Pete