Unanswered

Power Apps Dataflows Suddenly Stopped Working in One Environment

(2) Share

Report

Posted on by CU23091305-0

Hi,
We have several Sandbox environments and an application in one of them used by about 150 users (150 active per-app licenses). The app does not follow ALM, but please don’t ask why. There are several Dataverse tables and a few Dataflows that run every morning to pull data and load it into Dataverse tables.

The problem is that since Thursday, in this particular environment with the app, all Dataflow refreshes have completely stopped working. It’s unlikely to be an issue with the data sources from which the Dataflows pull data—for testing purposes, we created several simple Dataflows that only read data from Dataverse (without loading it anywhere), and the same issue persists. Every refresh attempt fails within a few seconds.

Any ideas on what might be wrong and what else we could check? We’ve submitted a ticket to Microsoft, and their Tech Team has already done some basic troubleshooting, but judging by how it was conducted, I doubt the issue will be resolved quickly.

I should add that this problem only affects this one environment. Another environment of the same type and region works perfectly fine with Dataflows. Also, these are Power Apps Dataflows, not Power BI Dataflows.

Error message always the same:
There was a problem refreshing the dataflow. Error code: UnknownError. (Request ID: 9a2da271-c89b-41ad-bj80-5115aaeb00cb).

A curious thing—when I open the Dataflow in edit mode, Power Query can fetch and process fresh data without any problems. The error only occurs when the Dataflow runs after exiting edit mode (and publishing), failing within a few seconds.

Here’s what we’ve already checked:

- The environment is not in Administration mode

- Logging in using incognito mode

- Removing and recreating connections

- Creating new test Dataflows from scratch by different users

- Adding the Dataflow to a Solution, then exporting and re-importing it

- Dataverse update

- Running the refresh via Power Automate

- Scheduled refresh

- Checking DLP Policy

Do you have any other suggestions on what we could check or test?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Redbird 59 on at

Like (0)

Report

We also have this issue.

A dataflow pulling data from Snowflake (likely not a factor) worked on one environment but not in another.

We have subsequently tried rebuilding the dataflow in 2 other environments where they work.

DLP Policy is the same for all environments. We've also tried using different user accounts.

In our case, the dataflow didn't stop working, but didn't start at all on the problem environment.

Was this reply helpful? Yes No
CU23091305-0 12 on at

Like (0)

Report

Just for your information, Microsoft Support hasn't resolved the issue yet, and in fact, they haven't made any progress at all. Moreover, we are in contact with two Microsoft support teams simultaneously, and it seems like the tickets we create are completely out of their control. If they send us an email on Friday evening and we respond on Monday, a new ticket is created, a new person is assigned, and everything starts over.

The second team is even worse. A few days ago, they asked me to send one of the Dataflows exported as a CSV file—which is not even possible (lol). When I told them that, they sent me instructions on how to export a Dataverse table as a CSV file, which makes it clear they don't even remember that the issue is about Dataflows, not Dataverse tables. They specifically mentioned, "Send Dataflows as a CSV file."

From our perspective, the issue is clearly related to some system plugins or an underlying component that may have failed to update. Imagine having multiple critical applications, and out of nowhere, nothing works—while Microsoft is unable to help.

Was this reply helpful? Yes No
SJ-11090959-0 9 on at

Like (0)

Report

Hey @CU23091305-0,

any updates on this? We are facing the same issue.

Dataflows are running fine on DEV Environment.

On TEST Environment connecting to datasource and fetching data works fine, but same refresh-error occurs after publishing the dataflow. Strange thing is also, that the same dataflow gets the same refresh-error in PROD Environment with same timestamp like TEST Environment, even though a refresh wasn't triggered in PROD.

Was this reply helpful? Yes No
CU23091305-0 12 on at

Like (0)

Report

@SJ-11090959-0
no, two different microsoft teams work on the issue and it is almost 2 months. It is actually disappointing how Microsoft Support is limited when it comes to troubleshooting. They outsource support to some external companies which are not able to check your backend because of security. I just wonder in what cases these Support teams can help you - showing you how to open incognito mode in the browser? Not sure.

Was this reply helpful? Yes No