Tag Archives: Power BI

ByHariharan Rajendran

Prepare data for Power BI  – Local File

As we discussed the levels in Power BI, the first level is creating dataset.

To start prepare the dataset, first sign in to the power BI here,

This article will talk about, how to create a dataset from local file.

Steps to import the local file,

  1. Sign in to the Power BIPowerBI
  2. Check for Get Data and click as like below.
  3. Click on “Get” under FilesPowerBI1
  4. It will display the options to import the files from different places.PowerBI2
  5. Click on “Local File”
  6. Select the file from your local folder and press open. Make sure that file should have both dimension and measure values. Power BI only supports Excel and CSV files and Power BI Desktop files.PowerBI3PowerBI4
  7. Check for uploaded files under Datasets.PowerBI5
  8. Dataset is ready to create reports and dashboards.

 

ByHariharan Rajendran

Basic Concepts of Power BI

Check my previous post about introduction to Power BI before going through this article.

Creating a report and dashboards are very easy in Power BI by simply pointing to the correct data source.

Levels in Power BI,

1. Create a dataset
2. Create a report on top of above dataset
3. Create a dashboard – Just pin a charts to display in dashboard from report.

Power BI is an application which we can use in online as well as in desktop. The steps provided in my previous article (Link) is for online version of Power BI.

To download the desktop version, click here. It has more options compare than online version.

Power BI has gateways which helps to keep the data fresh by connecting the on-premises data sources. It provides the flexibility to individuals as well as organization.

123