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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.