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)
It would be great to use excel in direct query mode!!!!!!!!!!!!!!
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
With 20 years experience working with tools having semantic layers like Cognos and Business Objects, I would say that semantic layers are often more trouble than they are worth (except for well designed OLAP models). For example, whilst it may seem great to be able to join data from completely separate databases it can lead to serious performance issues as usually full tables from both databases have to be downloaded to the (usually underpowered) report server. This is all hidden from the user who has no idea why the reports run so slowly. Therefore I would hope for something smarter. Something like the ability for power users to build multidimensional models which are then pushed down to SSAS Tabular which then hopefully could be partially populated on-demand (instead of requiring a full refresh) essentially caching it for subsequent users. Loads for frequently used Tabular models could then be streamlined, consolidated and formalised by IT on a continuous improvement basis.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Cannot upvote this enough. This is a huge gap right now that needs to have first priority from a dev perspective. There is no way to have governance over measure calculations for measures that have very well defined change control. If I'm using PowerBI to do financial reporting, I need to be able to control how measures are calculated, and the best way to do this is to have a published semantic model hosted either in Analysis Services or in something like SAP HANA.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is really THE thing that our business needs! I'm working on the implementation of Power BI in our company and it's just not convenient to have an intermediate SQL database.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This would provide my organisation with massive benefits and could be a positive reason for us to advocate selecting Power BI over another reporting tool like Tableaux.
Please provide support for Dashboards and reports using Direct Queries with calculated columns and translations.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
If we add a custom column in direct query mode, it says it is not supported in DirectQuery but it is needed.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
DIffinately needed....
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
From a data governance point of view we can only use DQ to prevent upload of confidential data the the cloud (however secure it may be). We have chosen Power BI for its self service capabilities but this gap renders that redundant. Calculations and modelling will have to be done on the SQL server by Devs, not power users in the business as was our intention. please please add the ability to create power query semantic layer with direct connect!
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Direct query and Import queries must co-exist
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Direct Query and Import queries must be able to co-exist