Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 Direct Query it works for one of the 2 tables but not the other one. Any ideas why? Both tables just connect to a SQL Server db view. I even changed the underlying SQL of the one which didn't work - to be the same as the SQL for the one that did work - and still unable to use direct query - can just use import.
Thanks,
Dan
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
45 | |
26 | |
21 | |
19 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |