cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmac412 Frequent Visitor
Frequent Visitor

Dual Storage Mode - not acting as direct query

Hi everyone, 

 

So I have a few questions about a dual storage mode table. 

 

I have an aggregate ( composite) model setup with a few dimensions in dual storage mode.

We embedded our report and on the website give the user ability to change some aspects of a dimensions (group things together ect.). They expect to see the changes instantly. Since the dual table stores a version of the table in memory, we dont see the changes take effect instantly. When refreshing the model they will come through. 

 

Is this performing as designed?Is there a way to get the table to act as direct query? Through the api can i force a refresh of one table? xmla endpoint may be able to refresh one table but i dont think its out yet?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dual Storage Mode - not acting as direct query


Is this performing as designed?

Yes this is performing as designed. When you have aggregations it's up to you to manage the refreshing of the import and dual mode tables.

 

Is there a way to get the table to act as direct query? 

I think you'd have to switch the table out of dual mode and make it Direct Query. But then any query using this table would not be able to use the aggregations.

 

Through the api can i force a refresh of one table? xmla endpoint may be able to refresh one table but i dont think its out yet?

I think the xmla endpoint is the only way to do this. This feature is still in preview, but If you have the model on premium capacity you should be able to enable the xmla endpoint on your workspace.

View solution in original post

1 REPLY 1
Super User
Super User

Re: Dual Storage Mode - not acting as direct query


Is this performing as designed?

Yes this is performing as designed. When you have aggregations it's up to you to manage the refreshing of the import and dual mode tables.

 

Is there a way to get the table to act as direct query? 

I think you'd have to switch the table out of dual mode and make it Direct Query. But then any query using this table would not be able to use the aggregations.

 

Through the api can i force a refresh of one table? xmla endpoint may be able to refresh one table but i dont think its out yet?

I think the xmla endpoint is the only way to do this. This feature is still in preview, but If you have the model on premium capacity you should be able to enable the xmla endpoint on your workspace.

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 (4,151)