Integrate Azure Cognitive Services with Power BI
- Set Up Azure Cognitive Services: Sign in to Azure Portal, create a new Cognitive Services resource, and note the endpoint and key for future integration.
- Prepare Power BI: Open Power BI Desktop and load your data set. Ensure you have data that can benefit from Cognitive Services, like text or images.
- Create a Custom Query: Use Power Query Editor in Power BI to call Azure Cognitive Services API. Go to "Transform Data" and select "Advanced Editor," using M language:
```m
let
Url = "https:///vision/v3.0/analyze?visualFeatures=Categories",
Key = "",
Header = [#"Ocp-Apim-Subscription-Key"=Key],
Body = Text.ToBinary(""),
Source = Json.Document(Web.Contents(Url, [Headers=Header, Content=Body]))
in
Source
```
- Integrate Query with Reports: Once processed, integrate the resulting data with your reports by creating visualizations or dashboard tiles to present insights.