Composite models in Power BI and Storage modes - what to pick???

When using composite models in Power BI, you have a choice for how to store your tables. Storage mode gives you options, but why would I pick one versus the other for my dimension tables? Adam has you covered!
Use composite models in Power BI Desktop
docs.microsoft.com/power-bi/t...
DirectQuery model guidance in Power BI Desktop
docs.microsoft.com/power-bi/g...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #CompositeModel #GuyInACube

[@venkateswarlubhojanapu1473]

Good morning Sir,your teaching is very excellent

[@remek5758]

I'm also impressed with the music x

[@zebakhan-gd1gb]

Good one!

[@aytugokumus7537]

Hi Adam
Thanks for nice video. Really helpful.
I have a question & problem. Would be great if you can explain how to do that..
Question ;
I have an excel table for projects, about 100.000 rows, with 10 columns that specifies the project specs. Question is ; In Power BI, i choose one project from table then i would like to find most similar projects from main excel table according to similarity based on columns data (each column will have weighted similarity factor & column context can be number & text).
And then i will filter & list them based on more similar project to less similar project by similarity score.
?

[@gamachu2000]

we are facing weak(limited) relationship in composite model. we need some requirement to have left outer join, but when dealing with composite model, its inner join. we read a few blog but there is a clear answer how to solve this problem. THey just explain. How do we get left outer join when using composite models

[@ryosakasaki3506]

Hi this composite model run with ssas tabular ? Thx for reponse please !!

[@sarvanikeella8069]

Hi! Great Video! We are using composite model but there is a limitation says calculated tables are not supported in powerbi service, for this reason we are not able to refresh the model. Any workarounds that you think of to make it work?

[@rebellious606]

I need to build a multiple slicer panel like a navigation bar which we can scroll it down like a navigation bar can someone help me on this

[@gier008]

I have problem setting my calendar table to Dual mode. The option is there, but I cannot choose it. The calendar table is created in Power Query using M code. Does someone know why I can't change it to Dual mode?

Why i can't change "Import" Mode Tables back to Direct Query or in other words: What is most efficient way to switch to Direct Query?
In general i prefer Import, but sometimes it would be interesting to compare and test...
How this will change with Hybrid?

[@olemew]

delete and create again

[@Yashone]

Anyone can share me video/online documents on powerbi shared service architecture??
Thanks in advance.

[@AllYoucanEat7]

More details please

[@4suc6]

He just forgot to explain what dual mode is

[@krishnakishorepeddisetti4387]

first comment ❤❤❤

[@dehiobu]

too much ranting and not enough contents, it is almost as if he is talking to himself.

[@davidmuller3849]

Had to quit because of the music.