Forum Discussion
Microsoft EmployeeShare 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.
Helper IThanks for this, I've just started getting the same bug and couldn't work out what it meant - for me it happened when I tried to build a new report on top of the working model, any refresh of the new one hit this error message, while the old one carried on working.
No problem. That's why I shared. 👍