Solved: Dataflow refresh issue

anvikuttu · ‎02-24-2022

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.

anvikuttu · ‎02-25-2022

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.

View solution in original post

anvikuttu · ‎02-25-2022

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.