Dataflow refresh issue

[anvikuttu]

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 · Accepted solution]

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.

[anvikuttu]

SQL Server. 

[BeaBF]

Hi @anvikuttu !

What is the data source?

BF