Forum Discussion

mykbitz's avatar
mykbitz
Advocate II
6 years ago
Solved

Data Flow Refresh Fails

Hello, Has anyone experienced any refresh fails with data flows?It takes unusually long, and eventually fails. I get the error below: Error: Data Source Error : The underlying connection was closed...
Dataflow
  • cvillegas's avatar
    cvillegas
    6 years ago

    What is the data source?

     

    If it's SharePoint Online check the main PBI support site:

     

    https://powerbi.microsoft.com/en-us/support/

     

    Power BI customers with Premium Capacities using SharePoint Online as a data source may see refresh not complete successfully with the following message - "The underlying connection was closed: An unexpected error occurred on a send". Power BI and SharePoint Engineers are investigating the issue and an update will be provided soon.

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

mykbitz 

 

If the steps are working in Power BI desktop, copy that steps and paste it in blank query of dataflow. It should work.

To improve the performance, you could try incremental refresh. For that (dataflow), you may need premium capacity.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂