Showing results for 
Search instead for 
Did you mean: 

SUMMARIZE With connection SQL Double

By using the SUMMARIZE function with a SQL Double / Direct Query type connection, of the SUMMARIZE Type (Table_Line, Table_Dimension [Field]), the function returns an error. It works perfectly in Import mode.

Status: New
Community Support

Hi @ggaudfroy


May I know your Power BI desktop version? 

Based on my test in Power BI desktop version 2.75.5649.961 64-bit (November 2019), it's able to create a new table with SUMMARIZE() function based on a DirectQuery query table, and this new table is in Import mode See: 




Best Regards,
Qiuyun Yu

Advocate I

Hello I have the last version.

But I do not take the same fields as the input table. But the one of the dimension table.

It works in import but not in Double