Sequence contains no elements error when i add a local data model

Hi Anonymous ,

The “Sequence contains no elements” error typically occurs when a sequence or collection that is expected to have at least one element is found to be empty. This could be due to a variety of reasons, and it’s often specific to the data or the operations being performed.

Here are a few potential causes and solutions:

1.Check if there are any issues with the data in your QA environment. This could include missing data, incorrect data types, or other inconsistencies that might cause the sequence to be empty.

2.There might be an issue with the query being used to retrieve the data. If the query is not returning any results, it could lead to this error. You might want to review your query and ensure it’s correctly formulated.

we had a user that reported a workaround by refreshing table by table in the model to identify which table was causing the issue. Then they went to Power Query Editor and created another query same as the trouble query, but from scratch. They deleted the one that was causing the issue, named new one exactly the same, and just joined it in the model as the old one was joined.

Best regards.
Community Support Team_Caitlyn