Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft EmployeeHi 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.
Advocate IThe thing is: If I have different Power queries in DQ to the same system (even in separate schemas in databricks for example) they are considered by Power BI as in the same source group and the relationships between them are regular. I don't know what is the technical restriction but I would expect the same when connecting in DQ to different datasets in the same PBI workspace.
The current behavior pushes me towards thinking I should put all the tables in the (in 30+) datasets into one enormous dataset, but I'm sure that will have many drawbacks.
Or is there another setup that would work better for this use case? Any thoughts are welcome.