Power BI Performance Issue - Scheduled Refresh

[rhariharaneee2]

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

[Anonymous]

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.

[v-alq-msft]

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.