This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi Folks,
I have connected my Power BI to a folder where i have close to 20 excel files. However, if 1 excel file has some error then my Power BI fails to refresh even though the other 19 excel files are good to go. So my question is if there is any way where i can refresh the Power BI dashboard for all error free excel files and flag the excel file that has an error?
Solved! Go to Solution.
In your query, at the step that shows the column of "Table"s (before you expand them), you can right click on the column header and choose Remove Errors. This will remove the rows that have errors, so your query will refresh.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
In your query, at the step that shows the column of "Table"s (before you expand them), you can right click on the column header and choose Remove Errors. This will remove the rows that have errors, so your query will refresh.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.