Forum Discussion

Ynr225's avatar
Ynr225
Icon for Helper II rankHelper II
1 year 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
    1 year 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
1 year ago

You can try to create two dataflows for each source and see which one is causing performance issue. Then bring them as linked entity in final Report Dataflow. 

  • Ynr225's avatar
    Ynr225
    Icon for Helper II rankHelper II
    1 year ago

    Hello abpgupta ,

     

    Thanks for responding. Actually i have taken three excel sheets in lan folder and applied transformations. After that i have taken sql server as a data source and i merged that sql server database with above three excel sheets. Once merged i manually refreshed and its failed. Below is the screenshot for your reference.

     

    Table1, Table2 and Table3 are created using excel sheets. Table4 is sql server database merged with Table1, Table2 and Table3.