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 Imp...
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