Refresh of table from dataflows just keeps running

Hi un97 , Thank you for reaching out to the Microsoft Fabric Community Forum.

If andrewsommer ’s cache and preview suggestions didn’t help, the next likely cause is that Power BI Desktop is getting stuck while resolving the OData connection from your Power Platform Dataflow. This usually happens when there’s a credential or privacy-level mismatch or when the Dataflow entity itself is misconfigured or too large for the OData endpoint to stream efficiently.

Start by re-authenticating the Power Platform Dataflows connection under File -> Options and settings -> Data source settings -> PowerPlatformDataflows. Edit permissions, set the privacy level to Organizational and sign in again using your Microsoft account or OAuth2. After saving, close and reopen Power BI before refreshing.

If the issue continues, try refreshing the same Dataflow directly in the Power BI Service (from the workspace where it lives). If it also hangs there, that confirms the issue is in the Dataflow itself, possibly a broken entity reference, query timeout or circular dependency. Opening and re-saving each query in the Dataflow editor usually helps identify which step is failing.

In a few cases, refreshes hang only in Desktop because the OData feed is throttled or too heavy. To confirm, temporarily filter your Dataflow entity to a small subset (for example, the top 1000 rows) and see if it refreshes. If it does, you’re likely hitting a feed timeout or memory limit; moving the Dataflow to a Fabric Dataflow Gen2 or connecting via a Lakehouse instead of OData resolves that.

Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Dataflows Considerations and Limitations - Power BI | Microsoft Learn

Thank you andrewsommer for your valuable response.