cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mattr_TEM Regular Visitor
Regular Visitor

Storage Mode Mixed

I have created a data set with mulitple direct query tables.  I noticed the other day that the desktop version notes in the bottom right corner "Storage Mode: Mixed".  I went through all of the tables and found that four of them are noted as "Import" in the field properties.  I then double checked the queries in the Power Query Editor and they are all set as Direct Query. 

 

Anyone else have this happen?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Storage Mode Mixed

hi, @Mattr_TEM 

This is a normal case, Power bi now supports composite models.

You could get data by Import and DirectQuery together.

When you did this, you will see "Storage Mode: Mixed" in the bottom right corner of power bi desktop.

You could change it to single mode by click here

7.JPG

See more details by this document:

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Storage Mode Mixed

hi, @Mattr_TEM 

This is a normal case, Power bi now supports composite models.

You could get data by Import and DirectQuery together.

When you did this, you will see "Storage Mode: Mixed" in the bottom right corner of power bi desktop.

You could change it to single mode by click here

7.JPG

See more details by this document:

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 47 members 987 guests
Please welcome our newest community members: