Unexpected error: Internal error DirectQueryUnexpectedEndOfStream eror while refreshing

The DirectQueryUnexpectedEndOfStream error in Power BI typically indicates an issue with data streaming — often related to connectivity or internal data handling, even when you're using Import mode. Power Query still pulls data via a streamed preview from Dataflows, which can cause this error, especially with large datasets (~200K rows in your case).

🚑 Possible Causes and Fixes:

• 💥 Dataflow connectivity issues:
  Make sure the connection to your Dataflow is stable. Corporate firewalls, VPNs, or proxy servers may interrupt the data stream.
• 📊 Complex transformations in Power Query:
  If you're using operations like Merge, Join, or custom steps, try simplifying them or disabling data previews (via ⚙️ Options > Data Load).
• 🔄 Try the following:
  • In Power Query: right-click the table → disable and re-enable Enable Load
  • Ensure Allow Native Queries is enabled (if applicable)
  • Split the table using filters by date or key to load smaller chunks
• ⚠️ Dataflow limitations:
  Even in Import mode, Dataflows might truncate streams due to service-side limitations (e.g., memory, timeout, row limits).

🔧 Debug Recommendations:

1. Enable Diagnostic Tracing (File → Options → Diagnostics)
2. Review Power Query steps: disable them one-by-one and test
3. Try refreshing from Power BI Service — does the error happen there too?

This issue may relate to known Dataflow streaming bugs, which persist even in Power BI Desktop July 2025 (v2.145.1105.0). Consider temporarily avoiding Dataflows if possible.

🧪 Workarounds:

• Export the Dataflow to a CSV or Excel file and import it locally
• Create an intermediate staging table in SQL or a flat file source

Try the suggestions above and let me know at which point the error still occurs. I can help you isolate the failing step in Power Query.

📘 Useful links:

• Power Query Documentation

```