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

Report Storage Mode when using ADDCOLUMNS Dax?

Hi Geeks,

 

I have a report which has developed using direct query. I am using ADDCOLUMS function to summarize some data in the report. Once i create the table with ADDCOLUMNS Storage mode of the report changed to "Mixed". And also i see schedule refresh has been enabled in the Power BI service. Do i need to enable the schedule refresh in-order to update the data of that table created usinng ADDCOLUMNS? 

 

Regards,
Maddy

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Report Storage Mode when using ADDCOLUMNS Dax?

Yes, If you've created a calculated table using DAX you've effectively created a composite model and this new table in using  in-memory storage and will need to be refreshed on a schedule in order to pick up any new data. 

4 REPLIES 4
Super User
Super User

Re: Report Storage Mode when using ADDCOLUMNS Dax?

Yes, If you've created a calculated table using DAX you've effectively created a composite model and this new table in using  in-memory storage and will need to be refreshed on a schedule in order to pick up any new data. 

Highlighted
maddy Member
Member

Re: Report Storage Mode when using ADDCOLUMNS Dax?

@d_gosbell 

 

Thanks for the reply. So if i use New Table option that will turn the direct query report to composite model?

Super User
Super User

Re: Report Storage Mode when using ADDCOLUMNS Dax?

That is correct, because the calculated table feature creates an in-memory table. If you don't want a composite model you would have to either look at trying to add a calculated column to your direct query table, those are supported now provided you only do calculations on a row by row bases (so you can't calculated ratios or rankings that require comparing data in the current row to other rows in the table). Or you could look at pushing the logic down to a SQL view, maybe trying to use an indexed view if performance becomes an issue.

maddy Member
Member

Re: Report Storage Mode when using ADDCOLUMNS Dax?

@d_gosbell 

 

Thanks for the explanation. Yes performance has become an issue in my report. I would consider doing the calculations in the SQL query itself. 

 

Regards,

Maddy

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 114 members 1,626 guests
Please welcome our newest community members: