Forum Discussion

amnaanwer's avatar
amnaanwer
Regular Visitor
8 years ago
Solved

Issue in Power BI Desktop File Refresh

Hi everyone,

 

I have connected my Power BI Desktop file to my OneDrive for Business account. When i refresh my pbix file from Refresh button in 'Home' tab, it gives me error in all of my files as shown in attached screenshot. However, when i individually refresh these files then it gives no error. How can i resolve this issue so that i can refresh all the files at same time by just clicking on refresh button?

 

 

Regards,

Amna Anwer

  • Anonymous's avatar
    Anonymous
    8 years ago

    HI amnaanwer,

     

    I'd like to suggest you turn on the 'parallel loading of tables' feature to loading tables at same time instead queue loading.

    It will ignore failed table in queue and loading next tables.

    In addition, if your tables contains reference from another table, it will also break loading when reference table failed loading.

     

    Regards,

    Xiaoxin Sheng

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI amnaanwer,

     

    I'd like to suggest you turn on the 'parallel loading of tables' feature to loading tables at same time instead queue loading.

    It will ignore failed table in queue and loading next tables.

    In addition, if your tables contains reference from another table, it will also break loading when reference table failed loading.

     

    Regards,

    Xiaoxin Sheng

     

  • augustindelaf's avatar
    augustindelaf
    Impactful Individual

    amnaanwer Hello,

     

    -Can you send a sample of your file ?

    There might be a problem with the volumetry, if refresh works for each file individually.

     

    I often had the same problem with an Excel source (there were formula errors in the Excel spreadsheet)

    Keep me informed !

     

    Best Regards,

     

    Augustin