Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Maybe this is a known bug? Refreshing two datasets where both datasets have a relationship between tables of the same name in both datasets causes a "Sequence contains more than one matching element" error.
I tried to workaround this (without renaming one of the tables) by setting the data load settings to not load in parallel, but no luck. (Given you can add the datasets individually without issue.)
BTW. discovered this when trying to pull together a report based on the two datasets, no fancy interlinking being done either.
NB: below pic has different table names showing, but underlying dataset has identical naming.
I did find it interesting that this is an issue given the table exclusion rules are being set by lineage tag.
interesting, thanks for reporting.