Forum Discussion

anvikuttu's avatar
anvikuttu
Advocate I
4 years ago
Solved

Dataflow refresh issue

Hi Team, When I refresh dataflow I am getting rather an unusual error msg "Error: PipelineException: Internal error DirectQueryUnexpectedEndOfStream. ." The data is just more than a million records,...
  • anvikuttu's avatar
    4 years ago

    I think the issue is now resolved. There were a couple of let statements within the M query, which caused this issue. Though this step was technically correct, the PBI service was not able to handle this calculation. So I separated out these queries as separate tables and then did the joins. With smaller data, these multiple let statements didn't create problems.