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.
- jeroenterheerdt
It's just a design choice from our side, given that we manage the Power BI dataset for you.
- ManuGP
Then that's my feedback: if relationships across datasets were regular (by considering one PBI workspace as a single source group) it would make this preview feature much more powerful.
Thanks!
- jeroenterheerdt
thanks for the feedback - I will discuss this internally, but I don't think this is going to change soon.