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)

All responses (1)

Answers (0)

developerAJ 4,611 on at

Like (0)

Report

Dataflow refresh returns error while Power Query preview loads successfully

if you can provide some sample images of your issue it would be helpful to understand the issue

Was this reply helpful? Yes No