Forum Discussion
Cant access my direct query code
hi Anonymous
When you use parameters in the SQL query, the gear icon don't show the query.
You need to edit it in Advanced Editor
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#the-advanced-editor
Regards,
Lin
I am accessing several tables with several million rows and when I tried before using Direct Querry I decided to look for a better route after it was taking more than 45 minutes to refresh the data
Community ChampionJust to clarify Anonymous using direct query or import query has no impact on whether you use the Advanced SQL statement screen or do all transformations in Power Query. You just have to tell Power Query when you start you want to use Direct Query before you start.
I do both import and direct query, and avoid advanced SQL statements. In fact, you cannot do a direct query with an advanced SQL statement and do any further transformations. As soon as you do the simplest thing, like removing a column, you will get this error: