Forum Discussion
Getting Error in Column profiling area
i have created a csv file and imported in powerbi and in power query editor i am getting error in column profiling area . how can i correct this error. datatypes of records are correct .
Omid_Motamedise I once again tried deleting the csv from power query and loaded once again and it did not throw any error . problem solved .
6 Replies
Hi kathiravan2026, remember that you are only seeing the top 100 rows of your CSV data. I suggest clicking on 'Keep Errors' to understand this issue. Alternatively, if you prefer, there is a similar function on the icon on the right side called 'Remove Errors'.
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Zanqueta Hi , I once again tried deleting the csv from power query and loaded once again and it did not throw any error . problem solved .
It might be because of the last step in your power query, which is related to determining the column type, remove it and see does it works.
Omid_Motamedise I once again tried deleting the csv from power query and loaded once again and it did not throw any error . problem solved .
Hello kathiravan2026.,
Thanks for sharing the update. we’re glad to hear that your issue has been resolved and thank you as well to Omid_Motamedise for providing helpful guidance.
Your insights and workaround will definitely benefit other community members who may experience similar issues.We appreciate your contribution. Please continue using the Microsoft Fabric Community Forum .
Hey,
This error sometimes occures. If it happends I just click to another query and back. This often already fixes the problem. Or add a new step and delete it again to force Power Query to reload the profile statistics.
