Skip to content

SqlSkull

SQL Server | SSRS | SSIS | Power BI | DAX
  • Home
  • About Us
  • Microsoft SQL Server
    • SQL Basics Concepts
    • SQL Advance Concepts
    • SQL Interview Q & A
    • SQL Server Tricks & Tips
  • SSRS
  • SSIS
  • POWER BI
  • Python with ML
  • Microsoft Azure
  • HTML Color picker

SqlSkull

SQL Server | SSRS | SSIS | Power BI | DAX
  • Home
  • About Us
  • Microsoft SQL Server
    • SQL Basics Concepts
    • SQL Advance Concepts
    • SQL Interview Q & A
    • SQL Server Tricks & Tips
  • SSRS
  • SSIS
  • POWER BI
  • Python with ML
  • Microsoft Azure
  • HTML Color picker
Home ยป Connect POWER BI with AZURE blob storage

Connect POWER BI with AZURE blob storage

  • by Pradeep Raturi
  • 1 Comment
  • Data Visualization With Power BI, POWER BI

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.

 




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




 10,678 total views,  5 views today

Share this:

  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Reddit (Opens in new window)

Related

Tags:Access Azure Blob storage data in Power BIAzure blob storageazure blob storage accountConnect power bi to azure blob storageconnect power bi with azure blob storagehow to connect power bi to azurepower bi azurepower bi connectivity with azure blob storagePower BI Desktop

1 thought on “Connect POWER BI with AZURE blob storage”

  1. Prabha May 24, 2022 at 11:34 pm

    Hi
    What if we have multiple folders in a container and need to generate report for each folder. Is it possible to change and connect to different folders using parameters ?

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

previousLEN Function DAX
nextConnect Power BI to SQL Server
Generic selectors
Exact matches only
Search in title
Search in content

Data Visualization with Power BI

  • Parameters in Power BI
  • What If Parameter Power BI
  • Change matrix background color based on value
  • Row-Level Security (RLS) in Power BI
  • Monitor usage and performance in workspace
  • Create a Data Profiling report
  • Power BI Report Performance Analyzer
  • Import JSON data files in Power BI
  • Calculated Columns
  • Install and Configure on-premises data gateway
  • Install and Configure on-premises data gateway (personal mode)
  • Sort By Months Name in Power BI
  • Introduction to Workspace in Power BI, Assign Roles and Permission
  • Rename a Dataset in Power BI Service
  • Visual zoom slider feature in Power BI
  • Create Relationship between tables when both tables having duplicate values
  • Create a calendar table in Power BI
  • Change the Data Source dynamically in Power BI using Parameters
  • Show Hide Measures in Line chart visuals using slicer in Power BI
  • Show or Hide Power BI Visuals
  • Dynamic Titles in Power BI
  • Add Saprklines to matrix or table in Power BI

Page Views

  • 710,042 hits

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Translate this website..

Search for Tutorial

Generic selectors
Exact matches only
Search in title
Search in content
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Home
  • SQL Basics Concepts
  • SQL Advance Concepts
  • SQL Interview Q & A
  • SQL Server Tricks & Tips
  • SSRS-SQL Server Reporting Services
  • SSIS-SQL Server Integration Services
  • POWER BI
  • Python with Machine Learning
  • Microsoft Azure
  • HTML Color picker

SqlSkull. All Rights Reserved

 

Loading Comments...