Power BI
CompletedComposite models when connected to AS models (PBI datasets and Azure Analysis Services)
Sander A. on 25 Jul 2018 14:39:12
We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources.
It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery.
This would stronlgy improve the enterprise features of Power BI.
Administrator on 18 Mar 2022 04:15:01
The preview is underway: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI. Please try it and provide feedback.
- Comments (254)
- Merged Idea (7)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This feature is a necessity. We need to be able to create relationships between live data and attribute files that are maintained in Excel. Also, website data can be blended with this as well. Truly a necessity.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I used Excel to connect to SSAS MD to build pivot tables using a connection string with the property (Extended Properties="LocaleIdentifier=4105") to load the English data from our Cube managed on French and English.
I'm using Power BI Desktop and I'm not able to change the connection string or to find how I can specify this setting in order to load English data from the cube.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
'@Everyone why would you have multiple cubes that need to be pulled together? The purpose of a cube is to pull all related data into a one view so that citizen developers can create reports with a controlled and standardized measures.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
As many have said, not everything is in one cube.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Please add this function
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
this is really a show stopper for my organization we should be able to use multiple data sources in SSAS tabular model. Please add this feature ASAP. We are planing to buy premium Power Services but seems like I have to think again for the same. This is the basic features in other BI tool not sure why this is not available.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is a very important feature and I feel frustrated and dejected when business users keep asking for this feature. This is going to be a huge difference in user adoption and we(IT) can't keep giving the same reason every time. I am struggling to understand why anyone from Microsoft wouldn't comment on this as to indicate there stand on this. I(and my users) am losing my patience. MS please let us know a) can this be done ? b)If can't, what is the reason
PS: The other tools are able to give this feature and why you can't ???
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
without this function PowerBi is just useless to work with SSAS. We need to mix data from SSAS,excel,sql and other sources. No we cant switch platform for our dashboards from Excel to PBI
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This would be such a nice feature!
Imagine letting users access the centralized model were all relations and measures are defined, and then let them add external data such as population to see correlation between sales and population in different cities.
Please add support for this ASAP! :)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Would be nice if someone from the Power BI Team provides an update on this. Even an update that says this is just way too complicated so don't expect it anytime in the near future is fine so we can stop thinking about it and follow alternate paths.