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

Hi Anonymous - they are indentical but I get an error trying to create the 1:1 relationship between them seemingly because of the 1:1 relationship between the account numbers across the 2 datasets.  Did you datasets have any other points of connection or was it just through the dates?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That was the only 1:1 relationship between the 2 datasets in our case, yes. But we did have multiple 1:M relationships in a different composite datasets model, but then no 1:1

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

    Ah.  That seems to be the issue that's 'breaking' it.  Thanks for taking the time to try and help, though, I appreciate it.