Connect Power BI With Azure blob Storage
To connect Azure blob storage with POWER BI , First you need to go through the following steps to verfiy that everything is setup correctly on Azure.
1> You must have an azure blob storage account, as you can see below azure blob storage account that is azuredataprdp
2> Then there should be a container in that account, Here we have a container named as Input.
3> Blob Storage container must have a file, here we have uploaded a .csv format file that is Cars.csv.
4> You can validate the file, Here is the preview of File Cars.csv
5> To connect an Azure blob to Power BI, you need to provide an account access key.
That you can get on the page of the Azure blob storage account (azuredataprdp) .
Go to Home page > click on Azure blob account azuredataprdp > Next, click on Access Keys under the Settings Lists , as you can see in below screen.
If you have validate all the steps then you are good to go to connect Azure blob storage with Power BI.
Following are the steps that is to be done on Power BI side.
Lets go step by step.
1> Open Power Bi Desktop > Click on Get data > Next, Click on Azure > then Click on Azure Blob Storage.
After that click on Connect button
2> After that, it will ask you Account name or URL, provide your Azure blob storage account name and click on OK button.
3> After clicking on Ok button, It asks you to provide Account key, you need to provide an account key then click on Connect button.
Once you click on Connect butotn, you will get to a Navigator dialog box. Which displays all the azure storage account lists and the containers.
On the left side you can see, there is a cars.csv files that we want to load in Power bi, ignore other files.
Just click on Transform Data button.
4>Once you click on transform data button, you get a screen as shown below.
Here you can view the preview of File, click on the combine file button as shown in below screen.
5> Once you click on Combine file button a Combines Files dialog box opens, here you can see and verify your file data, then click on OK button.
Also you will notice that there is a Sample file dropdown list that contains the list of all files that you have in your container. So what ever files you will select is loaded in Power bi Desktop.
The first file that is selected in dropdown is cars.csv.
6> Once you click on OK button, Data is loaded into power query editor as shown in below screen.
As you can see, Column Source.Name is created automatically, if you do not want any specific column, then click on choose column tab in ribbon pane as shown below.
7> In choose columns dialog box, uncheck the columns that you do not want to load, then click on OK button.
8> To load the Data into power bi desktop click on close and apply button
As you can see, data is loaded in Power Bi desktop, a table is created named as input.
Lets drag the table fields into table visuals to see the data.