Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've recently started transfering data from the CRM into Power BI and it literally brought in everything. There are 500+ tables that have been transfered. I'm playing around with a table that I will be using quite frequently but it's got 498 columns and most of that is full of null values.
Is there a more effective way of clensing the data or do I need to manually delete 470 columns?
Thanks
Solved! Go to Solution.
@michael_knight You can control click the columns you want to keep, right click the header and "remove other columns"
@michael_knight You can control click the columns you want to keep, right click the header and "remove other columns"
I'll give that a go. Thanks, Seth
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.