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)
@Toby Denbow unfortunately the link is broken, someone has a new link for the other idea?
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
this will be very helpful
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
this is a duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34922932-composite-models-when-connected-to-sql-server-anal
The other idea has a lot of votes so vote for that idea instead of this one.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This would be very helpful. I often need to flag a list of X (supplied in a spreadsheet) to data in our data warehouse and cannot add this in a model built in Analytic Services. To do so would be super useful.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
When dealing with large data sets this is a huge requirement. Awesome!!!
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This limitation also impact me. A simple addition is not possible.
Moreover I think it is something that can easily be added to a futur Power BI version.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Direct Query support with the ability to blend this source (summarized by source system) is crucial for its adoption as an Enterprise - Self Service Reporting and Dash boarding tool. Microsoft Power BI Team, request you to consider this as soon as possible.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Although this hasn't been a huge ask from most of my customers, I can definitely see this coming up more in the future. As many of our customers adopt the self-service BI model for their organizations, I can visualize this becoming more and more of an ask in the future as the volume of data continues to increase.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Agree with everyone here - we must combine multiple connections to get live and historical data into PBI.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I need LOOKUPVALUE to work with Direct Query mode to implement access rights