Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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.
Solved! Go to 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.
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.
SQL Server.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 5 | |
| 4 |