Security News > 2023 > May > Microsoft Dataverse: Going from Excel to new AI-powered tools

It does exactly what the name suggests: Users can drag and drop unstructured data from Excel - or give Copilot a link to the file - and the Power Platform will analyze it, enrich it with the extra information Dataverse needs, and turn it into an app, Nirav Shah, the vice president of Dataverse at Microsoft explained to TechRepublic.

Data in Excel might be easy for users to work with individually, but bringing it to Dataverse connects it to a range of new AI tools.

If a user keeps a list of company hardware assets like projectors in Excel and brings that into Dataverse instead, it could become part of an onboarding chatbot that helps new employees find out how to do things, alongside the official company HR tools.

Along with the ChatGPT plugins that Bing is standardizing for its AI chat and Power Platform connectors, the Teams message extensions that can be created with the Teams Toolkit will work as plugins for Microsoft 365 Copilot - the AI tools coming to the Office applications and services, which will have access to data from Dynamics 365 and Power Platform stored in Dataverse.

New AI-powered data hygiene tools in Dataverse do deduplication and smart data validation for objects like email addresses and URLs, as well as physical addresses.

That's useful because it means existing database developers don't have to learn a new way to query data, but the same technology is also how the different Microsoft Copilots can work with Dataverse data.

News URL

https://www.techrepublic.com/article/microsoft-dataverse-new-ai-tools/