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.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi rasika_pawar ,

Thank you for engaging with the Microsoft Fabric Community. Adding to what collinqalready suggested  this error can sometimes occur due to how the connection is configured.

Specifically, please check.

  1. You're using the Azure Databricks connector, not a generic ODBC or JDBC connector.

  2. The connection is made to a Databricks SQL Warehouse endpoint.

  3. Both Power BI Desktop and Gateway are updated to the latest versions.

Helpful Reference:

Troubleshoot compute issues - Azure Databricks | Microsoft Learn
Troubleshoot DirectQuery models in Power BI Desktop - Power BI | Microsoft Learn

 

Thanks for your response collinq .

 

Regards,
Yugandhar.