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
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.
Solved! Go to Solution.
Are you putting any queries in the Advanced dialog box?
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAre you putting any queries in the Advanced dialog box?
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCould we have a look at the query?
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.