Forum Discussion
Native query greyed out
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
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
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
3 Replies
- SMidFrequent Visitor
Doh, thanks to both of you.