Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi! We have been using this feature for almost 2 years. There is one limitation that I see that no one commented on.
I am now used to "Limited relationships" when connecting tables in DQ mode from different sources, or even btw imported and DQ tables. But when we have tables in different datasets in the same workspace I would have expected this to be considered the same source.
Would be nice to have a single Power BI workspace considered as the same island and thus any 1:* and 1:1 relationships be considered "regular".
Our use case is that we have many datasets and the idea was to let some self service users with Power BI desktop knowledge to "mix and match" to build their own datamodel without needing to import any data as everything is already available in the same workspace. The limited relationship concept is a little bit tricky and harder to take into account for end users (specially since there is almost no warning in Power BI dekstop about what this entails). Some use cases (requiring regular relationship) that are easy to achieve with data imported in the same dataset cannot be done when using data that is already imported in the workspace BUT in different datasets.
Hi ManuGP - thanks for the feedback. However, this is not how this is designed. Even if items are in the same workspace they are not going to be considered as one source group: a source group is tied to the source (each DQ source is a source group), with the exception of all Imported sources being the same source group.