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.
- Connecting Power BI to google analytics
- Connecting Power BI to an external API
- Connecting Power BI to a SQL Database
Connecting Power BI to google analytics
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
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.
Provide credentials for the database