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

selimovd's avatar
selimovd
Most Valuable Professional
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