Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Common steps or Data cleaning Template

Hi,

We have a Dashboard configured (data source : OData Feed) with  Scheduled refresh, where trying to get the data some of the blank, invalid, unneccessory data data to be removed. However, i also wanted to have some type templates that can helpful or referred during the data cleaning process on the data getting through online datasource (direct query) of PowerBI .

 

Hence, i am looking for some type of template on this, in case its available.

 

Thanks in advance 

 

Need Help

1 Reply

  • danextian's avatar
    danextian
    Super User
    5 years ago

    Hi Anonymous 

     

    It will be hard to come up with a template without knowing how the the data structure looks.  In the past, I'd sit down with the users and ask them which columns were needed, which rows to be removed, etc.