Forum Discussion

MDF-CET's avatar
MDF-CET
Frequent Visitor
1 year ago
Solved

DirectQuery Not Supported for Certain Desktop Users

A year ago, two DirectQuery tables were added to a semantic model I manage that primarily uses import mode for tables. Development has continued regularly on this mixed source report without issue. T...
  • wardy912's avatar
    1 year ago

    Hi MDF-CET 

     

     This has been previously reported here

    Re: Unable to use Direct query with Gen1 Dataflows - Microsoft Fabric Community

     

    Looks like the cause was the recent updates in BI

    Here are a couple of workarounds to try:

     

    Roll Back to July 2025 Version
    Users have confirmed that reverting to the July 2025 version of Power BI Desktop restores DirectQuery functionality and the “View” icons for eligible dataflows 1.

    Clear Credentials and Cache If you must stay on the August build:

    Go to File > Options & Settings > Data Source Settings > Global.
    Remove credentials for Power Platform/Dataflows.
    Re-sign in.
    Go to Options > Data Load, clear the cache.
    Restart Power BI Desktop.
    Connect via Get Data > Dataflows (not the legacy connector).
    Check for Unintended Transformations Even minor steps like Change Type can break DirectQuery compatibility. Ensure all transformations are handled inside the dataflow itself.

     

    I hope this helps, please mark as solved if it does, thanks!

  • MDF-CET's avatar
    1 year ago

    Thank you very much for that information wardy912 ! Based on the comments in the other post I got the most recent installer for Power BI and then ran the "repair" function since it recognized I had the latest release. The repair corrected the issue I saw and everything is back to normal now.