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
KeithCoxAuto's avatar
KeithCoxAuto
Icon for Helper I rankHelper I
5 years ago

Is there any plan to have one remote dataset filter more than one table in another remote data set?  I get an error that this is not supported currently.

 

I.e. a custom calendar that should have a relationship with both 'Leads' table and 'Accounts' table's "createdon" fields. 

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    which error do you get?

    • KeithCoxAuto's avatar
      KeithCoxAuto
      Icon for Helper I rankHelper I
      5 years ago

      'The table filters more than one table in the island which is not supported'

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Icon for Microsoft Employee rankMicrosoft Employee
        5 years ago

        ok, so you got the right error message. we are not planning to support this as its not a good practice. you want to limit the number of cross source group relationships. Can you not bring your custom calendar into the dataset that contains the leads and accounts table?