Azure Blob Storage Integration With Power BI

Introduction
 
In this blog, I will discuss how to connect the Azure BLOB storage with Power BI Desktop.
 
Run your Power BI desktop.
 
Use the "Azure Blob Storage" option for connecting blob storage. Please check the below figure. 
 
After clicking on the Connect button, the following window will appear. In that, we need to provide a storage account name. 
 
 
After clicking on the Ok button, the below window will appear. In there, we need to provide the storage account key. Please check the following figure.
 
 
After clicking on the Connect button, the below window will appear. In that, select your container and load the data.
 
As of now, we have two containers; I am selecting the first one.
 
 
 
After clicking on the Load button, data will be loaded to Power BI. One thing we should keep in our mind as of now is that we should pull up the file-related information, like
  • Filename
  • Folder path
  • File extension
We all know that for loading the images from blob storage, we need an image location.
 
For example, our storage account name is my-account and blob container name is images and the image name is logo.png. Here, the blob URL would be [http|https]://myaccount.blob.core.windows.net/images/logo.png and that is something you would put in the src attribute.
  1. <img src="[http|https]://my-account.blob.core.windows.net/images/logo.png" /> 
As of now, we are getting an image location in two different columns that are folder path and file name.
 
Let's concatenate the folder path and file name. Please check the below expression. 
  1. Column = CONCATENATE(pupandithimg[Folder Path] ,pupandithimg[Name])
 
 
After concatenation, we will get a proper image location so that we can render the image in Power BI.
 
 
 
For displaying the image, click on the data category option and select the image URL option.
 
 
Please observe the below figure. We are rendering an image from blob storage to Power BI report.
 
 
 
Summary
 
That's all.
 
We just used Power BI to get data from an Azure Blob Storage and generated a report.