Refresh the Dataset local to server

[mohammadrafic]

hi all,

We have many reports and dashboards on the powerbi.com server that schedule refresh is taking more time than the local refresh.

like server refresh takes 3hrs but local 2mins

So i am trying to avoid that. what i am thinking to create local gateway with oracle connection and refresh the dataset which is on server with power automate or if you have any other ideas.

Please advise what is the best way to that. thank you

[mohammadrafic]

Thank you @selimovd . it is on premises. let me try to repair the gateway and check the machine and internet performance.  some of table has alomost 300000rows of data.

let me try to use the incremental refresh. i have 1question if i use incremental refresh for last 30days. and any history data has modified. is it will reflect please

Is there any other way please let me know. thanks again

[selimovd · Accepted solution]

Hey @mohammadrafic ,

where is the datasource stored? Is it on premises? Then you need a gateway anyway. Check then if the gateway server is maybe overloaded.

How much data is transferred? If it's a big amount of data then it naturally takes longer. How good is your internet connection? If you have a 60 MBit connection and you have to upload 10 GB it will always take a while. Then maybe try to reduce the data, use incremental refresh if possible.

Go step by step to get the bottle neck.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic