Exploring the SEMANTIC MODEL in Power BI

In this video I go over the new model explorer of the October 2023 Power BI Update. Step by step I show the objects in the semantic model, what they are and practical ways of using them.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:41 Exploring the Semantic Model
01:38 Calculation Groups
09:12 Cultures
14:06 Perspectives
19:30 Roles
18:30 Hierarchies
21:20 Partitions
27:06 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[tam]

Thanks for using finance scenarios as an example. We're always dealing with CY, LY, Budget and Forecast and it's often a pain

[johnbert]

I just updated my PowerBI June 2023 version and it is a huge change in my perspective. Thank you so much Bas for putting up videos like this keeping us up to date! 🎉

[CinthyaBlois]

Calculated groups is amaziiiingggg! Thanks for this video :) I downloaded the material and I tested use a field calculations instead one single measure and it Fantastic!!!!

[umityalcin]

Your expression is very clear and straightforward. First and foremost, I would like to extend my congratulations to you. I have acquired a wealth of valuable information through our interaction

[iqfoot]

Thanks for covering this right away. What I really look forward to is seeing the use cases people come up with over the next couple months

[paulgallagher]

Brilliant as always Bas! You've managed to pack so many advanced concepts into half an hour. And explained each perfectly. So useful; thank you.

[DISISNOTFAIR]

the problem with calculations groups i faced 2 years ago and i believe its still there is that you cant do conditional formatting as much as you would like. lets say we have calculation group for current period, prior period and % difference. Now highlighting green/red for the % is pretty painful.

[RamzyTheDad]

Thank you for the quick and informative upload! Cheers!

[Sam-itnz]

Seeking this subject I found this, I hope it can be useful to my project

[McKaySavage]

Another really great and clear video! Thanks! One issue that came up to me in how you showed calculation groups is that in the matrix, there does not appear to be any header or title that shows the base measure was Actuals vs Forecast. This could lead to problems with end users if someone changes the base measure, forgets to change it back, and the rest of the team goes on making decisions on the report without knowing. Is there some built-in signal on the visual as to the base measure that you didn't show?

[TheRealOrangeAde]

Thanks Bas, Lots of interesting new elements to work with 🙂

[Elektrolite]

Great video. As it’s almost half an hour, it would be really useful if you could split it into chapters so we can skip to the parts of the video we need.

[businessinsights_AlexRobe]

Awesome Video again, Bas - THANKS!
@Changing the model to allow Incremental Refresh: when you convert the fact table Date column to datetime: Did you ever come across any issues with the relationship from Date table [Date] to the Datetime-column of the fact table. E.G. filtering, Time intelligence etc. - and if so would you still need an additional date column in the facts table? Thanks again!

[AnthonyCua]

Thank you so much for going through each and every par of the semantic model. It was so overwhelming at first!

[AnshulMarele-gbaa]

Hi,
I have power query table called "tbl_1".
I need to have another table called "tbl_2" sourcing data at "tbl_1" step no. 4.
There are other steps also after step#4. I don't want to duplicate table because it was decrease its efficiency. How can it be achieved without duplicating table?

[jamesrosicky]

This is brilliant! Finally I was able to grasp, how to set up an incremental refresh! Thanks a lot!

[gilaniseye]

Thanks Bas for all your hard work!
5:55 Could we apply group calculations for the 2 measures (Rev Actual & Forecast) in the same table/matrix?
In your example, you only showed the case for one measure (Rev Actual OR Forecast)
Again, thanks a lot for all the brilliant work!

[JohnOttoKnoke]

Great video, as always, Baz. Please make a video explaining how to use Power BI (.pbip) save options. Herzliche Grüße aus Guatemala

[jamalelbouatmani]

Good morning
Thank you for your videos are really very interesting,
I have a question: to export the Dashboard to Power Point without publishing it on the Power bi service, is there a way to do it
Thanks in advance

[pahadianalyst]

This is freaking the Semantic Model and BAS. Infact Bas is more awesome as I would not have understood any of it without this video. Thank you Bas