What and When to use Feature "skip files with errors" in power bi

[RahimZulfiqar87]

What and When to use Feature "skip files with errors" when we import data from a folder in power bi?

Examples?

[RahimZulfiqar87]

Hello! POWER BI Users, Can anyone guide and explain me with Examples about this option "Skip Files with Errors" when we use data to Combine and Load files from a Folder into POWER BI.

"Skip Files with Errors" | When and Why to use it? Any tutorial or Example to follow?

[ppm1 · Accepted solution]

Have you already read the documentation on it?

Combine files overview - Power Query | Microsoft Learn

It just adds a remove rows with errors step to your query. For example, if you had a file of a different format in the folder that caused an error, it would filter it out for you.

Pat

[Ritaf1983]

Hi @RahimZulfiqar87 
It's quite a philosophical question, there's no black and white here.
It depends on the developer's work style.
I like control, so if something goes wrong, the process should stop and flood me with problems.
Not to find out in retrospect that the reports already had errors.
Examples include:
The Excel-based report a user saves every week.
There's something wrong with Excel one week.
You have to ask yourself if you want the report to refresh and just ignore this excel and then there will be missing data.
Or everything will stop and users will yell and you'll look for the problem...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly