SUMMARIZE With connection SQL Double

[ggaudfroy]

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.

[v-qiuyu-msft]

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

[ggaudfroy]

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