Dataflow refresh returns error while Power Query preview loads successfully

(0) Share

Report

Posted on by YG-03011103-0

Hello everyone,

I’m currently building a Dataflow to load data from Dataverse. The query is designed to: Load data from a Dataverse table and join a column from another table.
The same Power Query code works perfectly fine inside the Power Query editor — it loads all rows correctly and displays the full dataset.

However, when I run or refresh the dataflow, some rows fail with the following error message:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

It seems that certain rows return HTML content instead of valid data records during the refresh process, even though they appear normally in the editor preview.

Is there a known cause or workaround?

Thank you very much!

Categories:

General Comment

I have the same question (0)