Forum Discussion
Refresh the Dataset local to server
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
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
2 Replies
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/DenSelimovicThank 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
