Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I'm using On Prem Dremio via the PB Dremio driver, and I had a working gauge chart when the table was in Load mode, but now changed to Direct Query, and it throws the error OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source.
Is a super simple calculation:
Turn Time = DATEDIFF(gate_transactions[entered],gate_transactions[exited],MINUTE)
Both entered and exited are timestamps in Dremio, and are recognized as such in PBI.
I tried casting the timestamps as text, then creating columns in PBI with TIMEVALUE, but it throws the same error.
I ran out of options. Any ideas?
Solved! Go to Solution.
Well, that didn't work initially, but the underlying reason was that I had a conditional formatting in place using a columns that changed when I switched from Load to Direct Query storage mode, but it makes more sense to do the calculation in the SQL, so I reset the format of the chart, and it worked.
Thanks!
Well, that didn't work initially, but the underlying reason was that I had a conditional formatting in place using a columns that changed when I switched from Load to Direct Query storage mode, but it makes more sense to do the calculation in the SQL, so I reset the format of the chart, and it worked.
Thanks!
@martinocando , Direct query has few limitations in terms of what all column calculations one can do. It allows you write a SQL, you can do the same in Sql and try
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |