Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Proud to be a Datanaut!
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Doh, thanks to both of you.
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.