Error fetching data for this visual - DirectQuery may not be used with this data source

[BiancaCiui]

Hi! We use a Databricks datasource for building Power BI reports. The SQL Warehouse of our workspace is set at the latest JDBC version (2.6.25 or later). We are using Azure Active Directory as credentials and this setup used to work for us. But since almost a month ago we keep seeing this error for visualizations inside our reports, visualizations that used to work.

But somehow we are able to see the data when viewing it in Transform window just fine. What can we do to fix this?

[SaiTejaTalasila]

Hi @BiancaCiui ,

Take a blank report -check your measures, and try reducing data volume or simplifying queries to see if DirectQuery works

Thanks,

Sai Teja 

[djurecicK2]

Hi @BiancaCiui ,

 I haven't run into this issue myself, but here are a couple of things you can try:

https://support.microsoft.com/en-us/topic/kb4093226-fix-directquery-may-not-be-used-with-this-data-s...

https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-error-DirectQuery-may-not-be-used-wit...