Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gurudayalsahu
Frequent Visitor

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 

 

1 REPLY 1
danextian
Super User
Super User

Hi @gurudayalsahu 

 

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.






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

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.