DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
  1. DZone
  2. Data Engineering
  3. Databases
  4. How to Integrate Power BI With Azure Tables Storage

How to Integrate Power BI With Azure Tables Storage

Power BI gives us much more flexibility to create awesome dashboards. They're even more powerful when integrated with Azure Tables Storage.

Ezequiel Reyno user avatar by
Ezequiel Reyno
·
Apr. 15, 17 · Tutorial
Like (4)
Save
Tweet
Share
12.29K Views

Join the DZone community and get the full member experience.

Join For Free

In this post, I created an Azure Function that stores data from our web application into Azure Table Storage. Today, I want to bring you a really powerful tool: Power BI, a data visualization tool that allows you to bring your data to life.

About Power BI

This is a great tool by Microsoft that allows us to create custom visualizations of our data from different data sources. Today, we are going to put the focus on Azure integration and how to bring to life our data stored in an Azure Table Storage. You can think Power BI as a tool to create awesome dashboards. In their words:

Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data. Monitor the health of your business using a live dashboard, create rich interactive reports with Power BI Desktop and access your data on the go with native Power BI Mobile apps. It’s easy, fast, and free.

Connecting to the Data Source

The first step is to download the Power BI desktop application for free on their website. I won't give the details — you guys already know how to do it. Once we have the tool, we need to configure our Azure Table Storage to pull data. First, we connect using our storage account name and key to connect our data source.

power_bi_select

Then we select our Azure Table Store to pull data from. In my case, I'll use the same I used when I create the Azure function.

power_bi_select_table.PNG

We are almost there. We already have selected our Azure Table Storage and selected our table to pull data, so now, we need to define our visualization. In my table, I have stored the city name on each request, so by selecting this column (as I did in the image below), Power BI creates a map data visualization displaying each row as a dot on the map.

power_bi_chart.PNG

The next step is to save our report locally and the publish it to the Power BI web. And that's it! Every time a new row is added to our Azure Table Storage, Power BI is going to pull this new data and display it in our data visualization. As you can see, it's a really simple example, but believe me when I tell you that Power BI gives us much more flexibility to create awesome dashboards. Later, I'll create another post where I will use the Power BI SDK to integrate this report in our custom website.

For more details on Azure functions, you can use this link. For more details of Power BI, use this link.

If you found this post useful please don't forget to press the like button and share it. If you are in doubt don't hesitate to ask a question and, as always, thank you for reading.

Database azure Data visualization Integration

Published at DZone with permission of Ezequiel Reyno. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • The Role of Data Governance in Data Strategy: Part II
  • Continuous Development: Building the Thing Right, to Build the Right Thing
  • Why It Is Important To Have an Ownership as a DevOps Engineer
  • API Design Patterns Review

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: