cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)