Power BI Refresh Error:
DataFormat.Error

What does this error mean?

Power Query received data in an unexpected format. Common cause: connecting to a standard dataflow instead of an analytical dataflow ('end of buffer' error).

Common causes

• 1You are connecting to a standard dataflow (one that stores data in Dataverse) using 'Get Data from dataflow' — only analytical dataflows support this connector
• 2The error message may read: 'DataFormat.Error: We reached the end of the buffer'

How to fix it

1. 1Check the type of dataflow you are connecting to — standard dataflows (Dataverse) cannot be accessed via 'Get Data from dataflow'
2. 2If your dataflow stores data in Dataverse, use 'Get Data from Dataverse' instead
3. 3Alternatively, recreate the dataflow as an analytical dataflow, which supports the 'Get Data from dataflow' connector
4. 4Ensure the dataflow has been refreshed at least once before connecting — tables are empty until the first refresh runs

Other query errors