Sum function is not working in MS Fabric

Hi Anonymous ,

Since your fact table is in dual mode, maybe the query for your card visual is hitting the direct query partition and this returns an error. The cause can very much depend on your backend architecture. If it is file based data lake then a frequent problem is that the structure or data types in a row of a file does not match with the column definitions of the SQL endpoint on top of it. The direct query partition migth also be linked to an on premise or any other kind of data source that is currently not available or reachable. Would you like to share some information about your data backend architecture, your dual mode table setup, and the filter context that is applied to the failing card visual?

Alternatively, you could just try switching the tables to import mode to see whether the problem comes from data source access or from within your data model. Or you could set a filter on the card visual that prevents from accessing the direct query partition to check for this being the root cause or not.

BR

Martin