Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I hope somebody can help me with this
my goal is to create a composit model with:
currently we have a datawarehouse with a SSAS tabular model. the problem is that it doesn't support composit models.
as far as i know the only option is to create the data model in pbi, which supports composit models. I've would really like not to start from scratch, since our model is rather big.
so far i've tried:
is there any way to convert the .bim to a .pbix other than manual labour?
or is there another way I could accomplish my goal?
Hi @fuglphoenix ,
Power BI has three connection methods.
Only Import and Direct Query support composite models.
In other words, if you use Live Connection mode to connect to SSAS, you cannot use the composite model.
(Direct Query mode is different from Live Connection mode, SSAS can only use Live Connection.)
Use composite models in Power BI Desktop
So for your problem, if you want to use composite models unless you import the model.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yes, i'm aware of that, that is why i'm trying to abandon our old SSAS model and create a new datamodel (directly in pbi) with an import-connection to our dwh (an sql-server) and an direct query-connection to the live feed.
but the ssas model is rather big, and i would love to avoid having to create alle the measures and dependencies again.
sorry if my question wasn't clear.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |