Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
3 years ago

Data loading in Power BI

Hi,

 

I would like to ask how to reduce time of loading data in Power BI. I am importing XML files in Power BI. I observed that whenever I import new tables, it loads not only new tables but also old tables which has been loaded already. So is it possible to make more effective process in this case?

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Hello Analitika ,

     

    You could do something called Incremental refresh, which only refreshes a certain timeframe were you specify it like the last 30 days and archive the rest so it wont refresh everything every time.

     

    learn more about this concept and how to implement it through this video https://youtu.be/Kui_1G6kQIQ

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

    • Analitika's avatar
      Analitika
      Post Prodigy
      3 years ago

      I am not talking about refresh but about data loading first time I load tables from xml file.

  • Digger's avatar
    Digger
    Post Patron
    3 years ago

    Analitika 

    1. Increment load (works only from webservices)
    2. disable Enable load option, leave only Include in report refresh