Microsoft Copilot Adoption

Hello. The tenant license for $200/25k messages is (was) an option to create custom agents with Copilot Studio. Since December 2024, a pay as you go plan is available: https://learn.microsoft.com/en-us/power-platform/admin/pay-as-you-go-overview. In my opition in most cases the better option. You do not need a 200$ license during development and test and also during prodution, you only pay what is consumed. The technical features are limited, but all use cases you described above are possible (API/gateway and some citizen development is needed). 

For example displaying data with adaptive cards: https://learn.microsoft.com/en-us/microsoft-copilot-studio/guidance/adaptive-cards-overview. But be aware, that Copilot Studio itself cannot create dynamic visualizations from data (graphs from tables).