How to create Visualizations and connect Power BI to different Sources

Power BI is an important tool and famous tool for business intelligence, In this article, we will go over some basics of how to use Power BI, which will include.

  1. Connecting Power BI to google analytics
  2. Connecting Power BI to an external API
  3. Connecting Power BI to a SQL Database

Connecting Power BI to google analytics

Step 1

Connect Power BI to google analytics by clicking on the Get Data icon in the top bar, and in the list of available sources select google analytics as a source.

Integrate GA and then select the different metrics/ desired chart time and filters for the report

Step 2– Change dates 

Then going forward you can change dates to get the report for the desired time frame

Steps 3

Add the required reports to a dashboard

CONNECT POWER BI TO API

STEP 1 – Get Data 

Click the Get Data icon and select the web option.

Step 2 – API Credentials

Select the Advanced option, provide the API URL , and provide additional request header parameters based on the API

Step 3 – Required Visualizations

Select the required visualizations and plot the data.

CONNECTING POWER BI WITH SQL

STEP 1- Select SQL Database

Select the SQL database option from the get data tab and put the URL and the port of the database in the next popup.

Step 2

Provide credentials for the database

About the author

admin

Mastering Data Engineering/ Data science one project at a time. I have worked and developed multiple startups before, and this blog is for my journey as a startup in itself where I iterate and learn.

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Copyright © 2023. Created by Meks. Powered by WordPress.