Forum Discussion
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 f...
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
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