Forum Discussion

dancarr22's avatar
dancarr22
Helper V
3 years ago
Solved

Direct Query with Dataflow working for one table but not another

Hello,   I built a dataflow with 2 underlying tables.  That worked properly and data loaded.  Enhanced Compute is set to 'On'.   When I connect to the dataflow from Power BI desktop and try to use...
Dataflow
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, dancarr22 

     

    It's possible that the table that is not working with Direct Query has a data type that is not supported by Direct Query.


    To use Direct Query, the data source must support the required data types and functions. If the data source does not support these data types or functions, Power BI will automatically switch to Import mode.


    You can check the data types of the columns in the table that is not working with Direct Query and compare them to the data types that are supported by Direct Query.


    Another possibility is that the table that is not working with Direct Query has a large number of rows or is too complex for Direct Query to handle. In this case, you may need to consider using Import mode or optimizing the table to work with Direct Query.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, dancarr22 

 

It's possible that the table that is not working with Direct Query has a data type that is not supported by Direct Query.


To use Direct Query, the data source must support the required data types and functions. If the data source does not support these data types or functions, Power BI will automatically switch to Import mode.


You can check the data types of the columns in the table that is not working with Direct Query and compare them to the data types that are supported by Direct Query.


Another possibility is that the table that is not working with Direct Query has a large number of rows or is too complex for Direct Query to handle. In this case, you may need to consider using Import mode or optimizing the table to work with Direct Query.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.