PowerBI Live connection to ssas - summarization

[Anonymous]

I have a power bi desktop that is connected to an ssas tabular model with live connection

there is a summarization on a numeric column and I want to remove it, ( its something like employee id)

But because this is live connection, I do not see an option to remove this summarization, how do I do that /

[Anonymous · Accepted solution]

HI @Anonymous,

Perhaps you can try to turn on the advanced operation to add the SQL statement to custom the result table structure:

Connect to Analysis Services tabular data in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , i doubt that is possible in the case of a live connection. You can try changing it direct query model, There is an option under the modeling tab.