Enriching data with AI
Power Query also includes ways to enhance data using AI services from Microsoft. These features integrate with Microsoft Azure Cognitive Services and require a Power BI Premium capacity or per-user license. The options for AI Insights include the following:
- Language detection
- Key phrase extraction
- Sentiment analysis
- Image tagging
Let's consider why each of these would be useful.
Language detection
When data contains free-text fields, and we want to use those in analysis, it's important to first ensure we know the language used in the text. The accuracy and usability of subsequent text analysis are enhanced when the language of a given text block is known. AI Insights provides capabilities to detect language and it is recommended to start with language detection before performing key phrase extraction or sentiment analysis. AI Insights can detect up to 120 languages and returns both the name of the language as well as...
