Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Are these calendars different between datasets? We had a situation where we connected 2 datasets, and each one had a calendar already with all the relationships in place. What we did in the composite dataset, is that we created a 1 to 1 relationship between the dates of the 2 calendars and hid one of them. This solved our issue.
Helper IHi 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?
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
Ah. That seems to be the issue that's 'breaking' it. Thanks for taking the time to try and help, though, I appreciate it.