Forum Discussion
View native query Grayed out
Here are a couple of things you can try.
For a SQL Query load:
- Connect using ODBC but do not add the SQL Query.
- Right click on the database and select Transform Data.
- Open Advanced Editor and add a comma after your last step.
- Call the next step something like SQL or LoadSQL. Make your code look like this
SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null)-
Now check to see if you can view the Native Query. If not then try adding an additional parameter:
SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null, [EnableFolding=true])For data loads without the SQL Query
1. On the Source step add HideNativeQuery=false like this
= Odbc.DataSource("data source", [HierarchicalNavigation=true, HideNativeQuery=false])Then check to see if you can see the Native Query.
I'm running ODBC and I'm not having issues seeing it.
Both ways I tried , but View Native Query Garyed Out.
Step 1 : Using SQL Query load the data result in Power query editor : "View Native Query" Garyed Out
Step 2 : Load the Data from source table into Powerbi desktop result in Power query editor : "View Native Query" Garyed Out
Solution SageHere are a couple of things you can try.
For a SQL Query load:
- Connect using ODBC but do not add the SQL Query.
- Right click on the database and select Transform Data.
- Open Advanced Editor and add a comma after your last step.
- Call the next step something like SQL or LoadSQL. Make your code look like this
SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null)
-
Now check to see if you can view the Native Query. If not then try adding an additional parameter:
SQL = Value.NativeQuery(Previous Step Name, "SQL Query Here",null, [EnableFolding=true])
For data loads without the SQL Query
1. On the Source step add HideNativeQuery=false like this
= Odbc.DataSource("data source", [HierarchicalNavigation=true, HideNativeQuery=false])
Then check to see if you can see the Native Query.
I'm running ODBC and I'm not having issues seeing it.
Syndicate_AdminAdministrator
Hello, how are you doing!
I have a similar prolama I read your post but I do not understand the point :
-Connect using ODBC but do not add the SQL query.
How should I connect? can you place an image ? Thank you
Same issue... solution: What WATSY recommended, but get rid of [EnableFolding=true]. If that's in the Advanced Query statement the wheel will be grayed out. Get rid of it an voila... Cheers.
