Hi Christopher....welcome to the Club
There are so many out there....here's a couple of links for the cheaper ones, which although they do work for pulling out codes and cancelling them down, they do lack a lot of other functions.
This one seems quite good, although I haven't tried it but it boasts quite a few features: https://www.ebay.co.uk/itm/MVDIAG-BLUETOOTH-USB-CAR-DIAGNOSTIC-OBD-SCANNER-AUDI-BMW-SKODA-VW-MERCEDE/263529694166?hash=item3d5b9803d6:g:2OUAAOSwcaFZEMnd
This one I can vouch for and is a great piece of kit for the money https://www.ebay.co.uk/itm/LATEST-ICARSOFT-BMM-V2-0-BMW-MINI-OBD2-CAR-DIAGNOSTIC-FAULT-CODE-SCANNER-TOOL/283009962052?epid=21018638200&hash=item41e4b55044:g:ufQAAOSwH9tbSjzt
Let us know how you get on and what you end up buying