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, however, with smaller data, I don't get this issue. Any ideas?

Additional info: I have a power bi premium license.

Let me know if you need any more information.

thank you in advance.
Error: PipelineException: Internal error DirectQueryUnexpectedEndOfStream. . RootActivityId = 00236128-be0d-4928-92ec-f106613b9932.Param1 = PipelineException: Internal error DirectQueryUnexpectedEndOfStream.  Request ID: fa559a00-f9eb-fe41-56f8-7bc742893de0. 

Need Help
  • anvikuttu's avatar
    anvikuttu
    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.

3 Replies

  • anvikuttu's avatar
    anvikuttu
    Advocate I
    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.