Forum Discussion

mohammadrafic's avatar
mohammadrafic
Helper I
4 years ago
Solved

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 tr...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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

mohammadrafic's avatar
mohammadrafic
Helper I
4 years ago

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