From the course: Power BI Data Methods
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Connecting to images as data - Power BI Tutorial
From the course: Power BI Data Methods
Connecting to images as data
- Images are data themselves that are stored in different formats than the tabular data we normally work with. On a high level, this process first involves importing image data as a binary object into Power Query. We'll then convert it into a text bit map with the help of a few formulas. Lastly, we'll load the bitmap into Power BI, and convert it back into image data by setting its data category as an image URL. Our course project focuses on California tourism, so let's bring our company Explore California logo into Power BI as an image. Notice it's a smaller image. Power BI supports thumbnail images, but not larger ones. So if you're working with larger images that you want to bring in as data points, you'll want to resize them first. We can use any connector to connect to our image, because Power Query doesn't have a built-in connector to image data file formats like PNG and JPEG, like we're using here. Instead of selecting text files, we'll select all files. And select the same…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Connecting to text files6m 57s
-
Connecting to CSV files5m 30s
-
(Locked)
Connecting to Excel files3m 32s
-
(Locked)
Connecting to online Excel files3m 45s
-
(Locked)
Connecting to PDF files4m 42s
-
(Locked)
Connecting to images as data4m 32s
-
(Locked)
Setting up folder connection7m 10s
-
(Locked)
Connecting to HTML and XML4m 30s
-
(Locked)
Connecting to JSON data4m 11s
-
Connecting to APIs4m 20s
-
(Locked)
Connecting to ODATA feeds2m 7s
-
(Locked)
Connecting to GitHub4m 6s
-
(Locked)
Using an R script connector3m 44s
-
(Locked)
Using a Python script connector2m 42s
-
(Locked)
Challenge: Getting data58s
-
(Locked)
Solution: Getting data3m 9s
-
(Locked)
-
-
-
-
-
-