Forum Discussion

rasika_pawar's avatar
rasika_pawar
Frequent Visitor
1 year ago
Solved

DirectQuery Error: DirectQuery may not be used with this data source

For one of our PBI report we're facing the "DirectQuery Error: DirectQuery may not be used with this data source-please consider moving to supported data source or upgrading the SQL server data sourc...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Thanks for confirming. Since you're using the January 2025 version of Power BI Desktop and the latest release is from July 2025, I’d recommend updating to the latest version. Sometimes older versions can run into compatibility issues, especially when using DirectQuery with services like Azure Databricks.

    Also, just to be sure, please check that your on premises gateway is up to date too.

     

    Warm regards,
    Yugandhar.

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

HI rasika_pawar ,

I think that you should confirm that your Gateway and Power BI Desktop are both current and up to date.  Then, try it again.  If it still fails, this might require a MIcrosoft support ticket.

rasika_pawar's avatar
rasika_pawar
Frequent Visitor
1 year ago

Hi,

Thank you for your response.

Yes, gateway is connected and it is online and PBI Desktop version is January 2025. Latest version is July 25. Is it causing?

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Thanks for confirming. Since you're using the January 2025 version of Power BI Desktop and the latest release is from July 2025, I’d recommend updating to the latest version. Sometimes older versions can run into compatibility issues, especially when using DirectQuery with services like Azure Databricks.

    Also, just to be sure, please check that your on premises gateway is up to date too.

     

    Warm regards,
    Yugandhar.