cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Datahungry Frequent Visitor
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Verifying files for errors before import into PowerBI

Hi @Datahungry,

Based on my research, I am afraid you could not achieve these features currently, you could summit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Or you could use the query editor in Power BI Desktop to clean your data before you import your data to the data model:

https://docs.microsoft.com/en-us/power-bi/guided-learning/gettingdata?tutorial-step=4

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Super User
Super User

Re: Verifying files for errors before import into PowerBI

Might be able to do something like that in R or Python perhaps. Are you thinking a pre-process or as part of the query?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Datahungry Frequent Visitor
Frequent Visitor

Re: Verifying files for errors before import into PowerBI

Right now I have no solution, so either would be helpful Smiley Happy

 

Is it possible to accomplish both?

 

Community Support Team
Community Support Team

Re: Verifying files for errors before import into PowerBI

Hi @Datahungry,

Based on my research, I am afraid you could not achieve these features currently, you could summit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Or you could use the query editor in Power BI Desktop to clean your data before you import your data to the data model:

https://docs.microsoft.com/en-us/power-bi/guided-learning/gettingdata?tutorial-step=4

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Verifying files for errors before import into PowerBI

Hi @Datahungry,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Datahungry Frequent Visitor
Frequent Visitor

Re: Verifying files for errors before import into PowerBI

Understood. Thank you for your support.