Forum Discussion

rhariharaneee2's avatar
rhariharaneee2
New Member
6 years ago

Power BI Performance Issue - Scheduled Refresh

Hi

   My report's dataset schedule refresh is taking too much of time. sometimes it is more than 5 hours and failed.

 

I am processing 150 csv files and getting 3 tables. example table A, B & C. Table A processed 100 files and Table B & C processed 25 files respectively and then Table A getting few columns from B & C tables so using merge transformation. 

 

This whole setup is taking more than 2 hours to refresh and maximum of 5 hours. How to improve the performance?

 

Thanks

Need Help

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, rhariharaneee2 

     

    Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, It is suggested to consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

     

    For further information, you may refer to the following link.

    https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Hari,

     

    Can you answer these..

     

    What is the time it takes when you refresh it from the Desktop ?

    Are your files in On Premise  or in the cloud/ Online (could be Blob / Sharepoint Folder / One drive) ?

    Is your workspace premium or shared?

    Can you check what is the size of your pbix file?

     

    Thanks,

    Nishanth.