Power BI composite model is one of the most amazing features delivered in Power BI.
But you may be wondering what's next. Well, what's next could blow your mind. And actually you could help us get there
I'll cover all that and more but if you want to become a Power BI Pro, make sure to subscribe and click that bell
So you are notified whenever I go live to answer your Power BI questions
Composite models bring directquery and import modes together now
I have a complete video which shows you step-by-step on how to build composite models. And what are the benefits of doing?
So I'm gonna link it in the cards and the details below and you can watch it later
But I'm gonna give you a quick summary. It's all about
Reducing the friction between IT and business and bringing them together
So in this scenario in a typical company IT
Let's say they have spent a lot of time energy money
investment invested in building a sequel data warehouse and
Now that can be made available to the business user and they can connect to it using the directquery mode
Which is great because they don't have to copy all the data over to the model
They can connect to it directly using power bi desktop. But of course, this is where
Sometimes business users got into trouble because they had this one other file sitting somewhere
It could be an excel file could be a SharePoint list could be something on the web that they were trying to connect to which
They wanted to bring in now
you can do that with the power of
Composite models and it combines direct query but still lets you import data from your own sources
so really empowers the business users and that's the whole mantra of
self-service bi the bringing IT and business together
But my friends this is where perhaps the problem starts because in a typical organization these days IT
does not
Expose the sequel where how sequel database warehouse to the business user
Instead they build a cube on top of it. This is a very common scenario now
This cube would be running on a technology like SSH tabular or something similar now
This is what the business user would connect to now. This is allowed. In fact this works great
They can connect to it similar to direct query in a live connection mode where they don't have to import all the data
Let me show that to you really quick how that's gonna work
so here I have a new power bi desktop window and I can say get data and I can point to
Analysis services once I do that I can just point to my analysis server
well
this one resides on my local machine so I can just say dot but the key thing is I can say
Connect live now once I hit okay. Watch what happens on this side and this side now when I hit okay, uh,
Well, okay after the step
So I connect to the specific cube that I want to connect to and now if you notice
That over here the data and relationship tabs are gone because I'm connected to the cube
The cube has the model and that is available to me over here and all the tables inside the cube
whatever the
calculations measures have been built are readily available to me at my
Fingertips so I can I can do something really quick and I can say show me
Sales by calendar year and pretty much I can analyze and slice and dice data. Any which way I want again
I'm connected using a live connection to that and you can also see in the corner over here
So that is the key scenario and this is really powerful. In fact, it's super powerful
Because this also lets you define your own
Measures so business user when they are connected to an SSA estab on the server
They can still say you know what? It's missing a measure so they can go in and say let's say net
profit and they can say is
sales
minus cost
and
That's a new measure and they can drag and drop and put it and use it in their visualization
So this is incredibly powerful, but let's go back
So this scenario is so far works, but remember the need for the composite model
well
The need came in when the business user had some other
Data set that they wanted to bring in and combine and and and again
This is more common than you would expect
They would have some excel files some
SharePoint lists or or some source from the web which you would want to connect in and right now
This is not possible. It would not allow you to do it
So now if you look at model and I have a finished one here
so again
This is connected to an SSA established to finish report but notice that the get data option is blocked out
So that is not an option. But my friend you can see the power of this you can see that once this functionality is enabled
how
Incredible would that be and you can make that possible? So you have the link right here and in the description below as well bitly
composite for SSAS comp for s SAS and
We got hundred votes and counting and so go ahead go to that link and cast that vote to help make this vision possible
Because who wouldn't want a happy ending wait
That didn't come out right who wouldn't want IT and business to live happily ever after
And if you're looking to learn power bi make sure to check out my power bi tutorial on my channel and if you get stuck
And have questions join me on my live talk power bi show on Fridays until next time power on my friend
Hey keep watching more videos and keep learning power bi but if you did enjoy this video
I would love to hear from you. So leave a comment like subscribe
All the good stuff while we're on my friends