Issue in Power BI Desktop File Refresh

[amnaanwer]

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

[v-shex-msft · Accepted solution]

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]

@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