Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
1 year ago
Solved

Unable to use Direct query with Gen1 Dataflows

Hi All,    we have been using Gen1 dataflows from past 5,6 months and able to connect to dataflow tables from pbi desktop in Direct query mode. But today, when i was trying to connect to my dataflo...
Need Help
  • JP8991's avatar
    JP8991
    1 year ago

    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.

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
1 year ago

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.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi vamshikrishna20 

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:

    1. File >> Options & settings >> Data source settings >> Global >> remove Power Platform/Dataflows creds, sign in again.

    2. Options >> Data Load >> Clear cache, restart Desktop.

    3. Connect via Get data >> Dataflows (not the legacy connector).

If the icon still isn’t there, stick with July until Microsoft ships the fix.