Tag: power bi

Using REST API as a Data Source in Power BI

Ben Richardson Leave a comment
Total: 1 Average: 5

Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs.

This article explains the usage of Rest API as a data source to import JSON data in Power BI from a remote location. Also, we’ll learn how to transform the imported JSON data into a tabular format. Finally, we’ll plot visualizations using the imported data.

Read More

Power BI REST API No Code Options

Ben Richardson Leave a comment
Total: 2 Average: 5

Microsoft’s Power BI REST API no-code option is extremely helpful as it allows calling Power BI REST API without writing a single line of code. Of course, you can call it programmatically using any programming language. Still, testing if Power BI Rest APIs are accepting requests and returning the right data, it is convenient to use the no-code options first. This article will explain how to do that.

Read More

Install and Configure ODBC Drivers for MySQL

Nisarg Upadhyay Leave a comment
Total: 2 Average: 5

This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover the following issues:

  1. Installing the ODBC driver on Windows 10.
  2. Configuring the ODBC data source with ODBC driver for MySQL.
  3. Creating a basic list report with PowerBI that uses the ODBC driver for the data population from the MySQL database.
Read More

Data Visualization in Microsoft Power BI

Ben Richardson Leave a comment
Total: 1 Average: 5

Contents

  1. Introduction.
  2. How to create a table.
  3. How to create a Power BI pie chart.
  4. Creating a line chart in Power BI.
  5. Report creation.
  6. Conclusion.

Introduction

The final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.

Read More

Loading and Managing Data within Microsoft Power BI

Ben Richardson Leave a comment
Total: 2 Average: 5

Contents:

  1. Introduction
  2. Importing data from Excel, SQL Server, and the Web.
    1. Importing data from Excel into Power BI.
    2. Importing websites into Power BI.
    3. Importing data from SQL Server Database into Power BI.
  3. Data Manipulation Basics in Power BI.
    1. Group By option.
    2. Splitting columns.
    3. Duplicating columns.
    4. Combining columns.
  4. Managing relationships within Power BI.
    1. Merging/Joining datasets.
    2. Model views/Relationship link.
    3. Hierarchies.
  5. Conclusions.

Introduction

This article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.

Read More