Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
ManuGP's avatar
ManuGP
Icon for Advocate I rankAdvocate I
3 years ago

The 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's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

It's just a design choice from our side, given that we manage the Power BI dataset for you.

  • ManuGP's avatar
    ManuGP
    Icon for Advocate I rankAdvocate I
    3 years ago

    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's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      3 years ago

      thanks for the feedback - I will discuss this internally, but I don't think this is going to change soon.