cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alepage Member
Member

how to avoid the imported variables to be zummarize

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.

 

Capture Dim Calendar.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
zoloturu
Advisor

Re: how to avoid the imported variables to be zummarize

@alepage ,

 

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

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!

View solution in original post

3 REPLIES 3
zoloturu
Advisor

Re: how to avoid the imported variables to be zummarize

Hi @alepage ,

 

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)

summarization.png

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!

 

 

 

 

alepage Member
Member

Re: how to avoid the imported variables to be zummarize

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?  

Highlighted
zoloturu
Advisor

Re: how to avoid the imported variables to be zummarize

@alepage ,

 

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

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!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,782)