Forum Discussion
Unable to use Direct query with Gen1 Dataflows
Hey all, it looks like this issue has been resolved. There was an update in Microsoft Store yesterday that has reinstated Direct Query and Query Folding in Power BI Desktop.
DirectQuery for Gen1 dataflows will only show if:
-
Your workspace is on Premium/PPU/Fabric capacity
-
Enhanced compute engine is turned on in the dataflow, and the dataflow has been refreshed
-
You connect through Get Data >> Dataflows and pick entities that show the small “View” icon (not plain tables)
If any of these conditions aren’t met, only Import is offered. Also, some recent Power BI Desktop builds temporarily hid the DirectQuery option updating to the latest version or restarting often fixes it.
Hi rohit1991
My workspace is Premium, Enhanced compute engine enabled, and refreshed. But still can't see view icon which was working till yesterday. Also this seems like issue with version since i was able to connect in July version but not in August version.
You’re right, it’s the August Desktop build, not your setup.
What I’d do:
-
Roll back to July Desktop (or use the Store build). The View icon for Gen1 dataflows shows again and DQ works.
-
If you must stay on August:
-
File >> Options & settings >> Data source settings >> Global >> remove Power Platform/Dataflows creds, sign in again.
-
Options >> Data Load >> Clear cache, restart Desktop.
-
Connect via Get data >> Dataflows (not the legacy connector).
-
If the icon still isn’t there, stick with July until Microsoft ships the fix.
-