Forum Discussion

Ynr225's avatar
Ynr225
Icon for Helper II rankHelper II
2 years ago
Solved

Dataflow refresh has failed in Power BI service

Hello All,       I was able to connect to data source at first on desktop, but it took 4+ hours to refresh.  Afterwards I was not able to, as it would result in a disc error (no space avail...
Need Help
Show and Tell
  • Ynr225's avatar
    Ynr225
    2 years ago

    I disabled "enabled load " on all sources except final merged one refresh is working fine. Is it recomendable to diable it?

abpgupta's avatar
abpgupta
Icon for Continued Contributor rankContinued Contributor
2 years ago

Can you disable "Enable Load" on all source entities? Just keep it enabled for final merged table. 

 

Ynr225's avatar
Ynr225
Icon for Helper II rankHelper II
2 years ago

I disabled "enabled load " on all sources except final merged one refresh is working fine. Is it recomendable to diable it?

  • abpgupta's avatar
    abpgupta
    Icon for Continued Contributor rankContinued Contributor
    2 years ago

    Recommended approach is what I mentioned in first reply to have two data flows and leverage linked entities to do the join in Target Dataflow. If you want to keep all calculations in single dataflow and doesn't need source table, you should disable load for source tables. That will also improve performance significantly.