Forum Discussion

kushal_nagendra's avatar
kushal_nagendra
Regular Visitor
4 years ago
Solved

Power BI refresh issue

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?

Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    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