Code Interpreter is great for "quick and dirty" data analysis & visualizations. I've seen it struggle with larger datasets (not sure what the current limit is) but I can certainly see this sort of stuff replacing basic BI at organizations.

Microsoft is working on embedding this sort of stuff into what they call Fabric - which is essentially meant to be PowerBI on steroids. I know in the current preview, you can interact with data using a chat-like interface ("Show me our revenue for the last 12 months sorted by customer") .