Forum Discussion

deluisp's avatar
deluisp
Frequent Visitor
9 years ago
Solved

Slow refresh with small excel as source

Hi, I'm new using PowerBI.   I'm using two differents Excel files as source, their size are 136kb and 250kb. The problem is that it takes a lot of time to refresh.   I load from the files o...
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    To be honest,  on first sight I don't see any code that would directly explain the slow refresh.

     

    10mb doesn't sound as a small Excel to me though. What are the numbers of records?

     

    I assume that the final result is what you require?

    So in fact "Hechos" is not 55x the number of records from "Maestro", but about 3x.

     

    This is what I would try:

     

    1. Use Table,Buffer for Source and each of your 4 tables.

     

    Source = Table.Buffer(Table.SelectColumns(Maestro,{"Clau", "Estat", "Data Creat", "Data Actualitzat", "Data Entrega"})),

    CreadasFinal = Table.Buffer(#"Creadas - Added Custom1"),

    Likewise for the other tables.

     

    OR:

     

    2. Create separate queries for each of your 4 tables and an additional query to combine these.

     

    Hope this helps.