ggaudfroy's avatar
ggaudfroy
Advocate III
6 years ago
Status:
New

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.

Data Modeling

2 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    6 years ago

    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's avatar
    ggaudfroy
    Advocate III
    6 years ago


    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

     

Completed Ideas