We’ve inherited a lot of data, now neatly organized in a Dremio Data Lake. Most team members use Excel or Power BI to access it. With all the excitement around AI, management (especially non-technical business units) are now asking for a chat-based interface to interact with this data and generate charts on demand—similar to the AI demos you see everywhere.

I’ve pointed out that Excel Copilot offers some of this, but they’re looking for a more conversational, dedicated chat experience.

Requirements/constraints: - Needs access control and auditability - Preferably integrates with OpenAI-like API - We’re an Azure shop with existing Microsoft contracts

Has anyone dealt with similar requests? What kind of approaches, tools, or architectures did you consider? Any pros/cons you’d highlight, especially in an enterprise context?

PS. English is not my first language, the question was made with deepseek. I hope it didn't butcher it too much.