I have a problem, I created a database in a CSV file and extracted it to power query. But I had a problem converting one column, specifically the column with names, from text to date and now I have only errors.

I’m dealing with a dataset containing over 200,000 rows of data and noticed that Power BI lacks the “fuzzy grouping” function. I’m uncertain if this feature has been discontinued. My challenge lies in reconciling variations in customer account names example Cartrack, CARTRACK PTY LTD, CarTrack (PTY) Ltd, etc. While I can address this manually for each account, the sheer volume of data makes this approach impractical. I’ve attempted to implement fuzzy grouping in Power Query for individual account names, but I’m unsure how to extend this solution to handle multiple accounts simultaneously. Fuzzy grouping has been instrumental in resolving similar issues in the past, and I’m seeking guidance on alternative approaches to achieve similar results efficiently.

I’m trying to extract a part of a string field [Short description] and place it in a new custom field in Power BI Query [NewDesc].

I need a hand trying to find why I am receiving “We cannot apply field access to the type Binary
“