Sum function is not working in MS Fabric

[Dipesh123]

 

Hello, I have 'Hours' column in fact table with data typeas 'Whole Number'. I have written measure in MS Fabric as 'Total Hours' as  SUM fact_data['Hours'] as Whole Number . But when I try to use this measure in Report itis showing error. This is same case with other  column as well . Please help me to resolve this issue. Please find attached screenshot for reference.

[eliasayyy]

hello there is no file and what is the error

[Dipesh123]

I have paste screenshot in question itself.

[eliasayyy]

Yes but i need to see the full error not the display that there is an error please so on yje visual press see detail please

[Dipesh123]

[Martin_D]

Hi @Dipesh123 ,

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