Forum Discussion
Direct Query for Power BI dataset (composite models) - Sequence contains more than one element
When trying to combine an existing Power BI dataset in my current PBix-desktop file, I get following message:
I was getting the same error while trying to refresh the semantic model in Desktop. I solved it by moving to a new table the measures I had created locally (I had initially added them to one of the DirectQuery tables).