In the previous post, we extracted a list of image URLs.
In this post we will perform the AI Insights vision transformation on the list of image URLs.
Important:Power BI Premium Capacity is required for AI Insights feature. You will need to be signed into the PowerBI Desktop to use the feature.
Step B: Perform AI Vision Insights transformation
There can be many Image Tags produced from the AI Vision transformation for a single image. So we will create another table and use the ImageId to establish a one to many relationship between the two tables.
Create a new table that references the Images table.
Rename the new table to ImageTags_VisionInsight.
Invoke the AI Vision transformation and select the ImageURL as the Image column.
Change the Privacy Level Settings
The AI Vision Insights returns the following outputs:
comma separated list of all tables sorted from highest confidence value to the least.
JSON value of all the tags with their corresponding confidence value.
single Tag string
corresponding Confidence value for the Tag
AI Vision was unable to process the image and the Error message is captured in this field.
5. Remove Following columns: "Tag images.Json","ImageURL", "WebURL"
6. Rename the following columns
Old Column Name
New Column Name
7. Sort the column by Imageid
8. Modify the address formula to also sort by a second column, the Confidence.