Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.