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

Пікірлер: 17

  • @venkateswarlubhojanapu1473
    @venkateswarlubhojanapu1473 Жыл бұрын

    Good morning Sir,your teaching is very excellent

  • @remek5758
    @remek57582 жыл бұрын

    I'm also impressed with the music x

  • @zebakhan-gd1gb
    @zebakhan-gd1gb2 жыл бұрын

    Good one!

  • @aytugokumus7537
    @aytugokumus75372 жыл бұрын

    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. ?

  • @sarvanikeella8069
    @sarvanikeella80692 ай бұрын

    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?

  • @gamachu2000
    @gamachu20002 жыл бұрын

    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
    @ryosakasaki35062 жыл бұрын

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

  • @rebellious606
    @rebellious6062 жыл бұрын

    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
    @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?

  • @AllYoucanEat7
    @AllYoucanEat72 жыл бұрын

    More details please

  • 2 жыл бұрын

    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

    @olemew

    Жыл бұрын

    delete and create again

  • @Yashone
    @Yashone2 жыл бұрын

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

  • @4suc6
    @4suc6 Жыл бұрын

    He just forgot to explain what dual mode is

  • @krishnakishorepeddisetti4387
    @krishnakishorepeddisetti43872 жыл бұрын

    first comment ❤❤❤

  • @davidmuller3849
    @davidmuller38497 ай бұрын

    Had to quit because of the music.

  • @dehiobu
    @dehiobu8 күн бұрын

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

Келесі