Verifying files for errors before import into PowerBI

Hi everyone,

I am using a folder as the "source data" for a power bi report. This folder is supposed to contains multiple files, all using the same columns, so that PowerBI can merge them properly.

However, users are making the following mistakes:

- entering two records with the same primary key in the same file

- creating records for which there's no dimension (ex: Sales for Customer XYZ, when there's no customer XYZ in the corresponding Dimension table.

Is there a way to verify files before import, to make sure no errors exist in the data, a get a list of errors to address? Specifically

- Identify duplicate primary keys.

- missing dimensions

- Identify wrong datatype (ex: text where there should be date)

- files with mismatching columns

Thanks in advance