how to avoid the imported variables to be zummarize

[Anonymous]

Hello,

When we load data from our DataWareHouse, using a SQL script, each time, Power BI set some variables to be summarized while we don't need that at all.

To reset those variables to don't summarize, it is very time consuming.

Do someone can propose me a solution to avoid that.

See the example below with Dim Calendar.

[zoloturu]

Hi @Anonymous ,

I don't see any variable on the screenshot, only table with fields. I assume you meant that after load data from Data Warehouse some your fields become automatically summarized (implicit summarization)

I recommend you to set Default Summarization to all fields to Don't Summarize, so then after next refresh of the report you will not have summarization on those fields.

Or you can change each field in data source directly (or via SQL query in Power BI) which you don't want summarize in Power BI to varchar data type. So then they will be imported as a text.

If you want to do that in one click, you can vote for an idea about it.

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

[Anonymous]

How do we set the default setting to don't summarize for all fields?  Is it possible to set this option to don't summarize for all tables?  

[zoloturu · Accepted solution]

@Anonymous ,

No such feature in Power BI at the moment. Only the idea to implement it in future - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17171438-add-an-option-to-force-all-table-columns-to-the-d

You can vote for it and make it implemented sooner.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question?Mark my post as a solution!