How to connect Azure Blobs to Power BI Service

A tutorial

Image credit: Microsoft

In this tutorial, we are going to connect data Azure Blobs to the Power BI Service. Power BI Service allows you to view, edit, and share Power BI Dashboards easily online.

Requirements:

• Azure Storage
• Power BI Desktop
• Power BI Service

Step 1: Upload your files to Azure

1. Make a storage account in Azure.
2. In that storage account, make a container. Set the “public access level” to “Blob (anonymous read access for blobs only)”.
3. Click on the container, and upload the .csv files. Hold down “shift” and click to upload multiple files at once.

Step 2: Connect Azure Blob to Power BI Desktop

Power BI Desktop is the Windows desktop application version of Power BI.

1. Create a new Power BI Desktop dashboard and hit “Get Data”.
2. Choose Azure → Azure Blob storage and hit “Connect”.