Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
This has been in preview for 2 years now. tessahurr: What are we waiting for to make it GA?
Advocate IVExactly my question! This was first published as a biggest thing in Power BI world at the time but now I hear nothing about this and not even a best guess for GA. It is annoying to know, that this feature is available but only in theory. There were so many bugs when testing this, that I am waiting for GA to continue any work with this.
Five days from the two-year anniversary of "a milestone in business intelligence."
I doubt that the mainstream media will recognize the importance of such innovation. But users that create and consume reports every day will immediately realize the impact of this change.
...
It is here, and it just works.
😫
I would like to chime in by saying I support Microsoft in not making a feature GA until it is truly ready for prime time. There has been bugs yes but to their credit they have not released to GA prematurely and they are throwing fixes at the bugs quite quickly.
Secondly, this is a very difficult thing to implement technically.
The feature looks to be largely implemented via extensions to the DAX language itself and implements relationships between the local and remote model by placing large lists of data inside DAX statements in dynamic sets.
Finally, if you are an enterprise model designer, it's important to understand how this feature works under the hood to help you decide whether or not you should use it in your particular scenario, taking into account its features and limitations - and other factors such as the size of your model. In some cases, extending a single, base model - is going to provide a far superior solution than composite modelling.
There is a setting DiscourageCompositeModels that can be used to control whether composite modelling is permitted at a dataset level.
- jeroenterheerdt
thanks all, we are not quite ready yet for prime time (or making this generally available). Yes, it takes a long time (longer than any of us want) but we are dependent on infrastructure changes that are taking longer than expected before we can declare GA.
