Dataflow Gen2 Not loading and refreshing data

Hello balafbm 

DataflowLakehouseInternalSqlNotProvisioned” is associated with SQL analytics endpoint provisioning failures during Dataflow Gen2 refreshes, particularly in migration scenarios from Fabric trial to paid capacity.

Dataflow Gen2 automatically creates a staging lakehouse, but prior to January 2025, a known issue caused the SQL analytics endpoint for this lakehouse to fail provisioning. This led to refresh errors like:
`Refresh failed. The staging lakehouse is not configured correctly` .

While this was officially fixed in January 2025, migration from trial to paid capacity can reintroduce configuration mismatches if the workspace or lakehouse isn’t properly reassigned to the new capacity .

Workspaces migrated from trial to paid capacity may retain outdated references to trial resources, causing conflicts in SQL endpoint provisioning

https://learn.microsoft.com/en-us/fabric/get-started/known-issues/known-issue-809-dataflow-gen2-refresh-fails-missing-endpoint

Please check:

Verify workspace assignments to the new paid capacity in the Fabric Admin Portal

https://community.fabric.microsoft.com/t5/Dataflow/Dataflow-Gen2-Couldn-t-refresh-the-entity-because-of-an-issue/m-p/3674125

Possible solutions:

Existing Lakehouse artifacts in the new Fabric Capacity workspace may lack proper SQL endpoint provisioning.
• Delete the current Lakehouse and create a new one. Republish the Dataflow Gen2 to reference the new Lakehouse

https://github.com/MicrosoftDocs/fabric-docs/blob/main/docs/get-started/known-issues/known-issue-809-dataflow-gen2-refresh-fails-missing-endpoint.md

Disable Staging in Power Query

Please try these and let us know if this works.

Thanks