Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Helper 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.

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi vamshikrishna20 

 

Thank you for contacting the Microsoft Fabric Community Forum.


This behavior is not due to your configuration but is instead a regression introduced in the August Power BI Desktop release, which has temporarily broken DirectQuery support for Gen1 dataflows. Even with Premium capacity, Enhanced Compute Engine enabled, and refreshed entities, the “View” option no longer appears, resulting in only Import being available. As of now roll back to the July Desktop build , where DirectQuery continues to function as expected. While some users have had partial success on the August build by clearing cache and credentials under Options & Settings, this does not consistently resolve the issue.  In the meantime, please consider upvoting the existing Idea Direct Query Mode Missing which was already submitted by JP8991  so the issue is prioritized.

Regards,
Karpurapu D.