Introduction

Power Query in Power BI. Source: dibyenduDeb.com

Before creating report, we need to take data from various source as necessary.

Get Data

How to use Get Data feature.

• Select Get Data

• Select Source of Data location: Excel, SQL Server, etc.

• Select File Data

• Change Data source.

  

  

Storage Mode

• Import: Allows to create a copy data in Power BI local from dataset source.

• Direct Query: Allows to commit query data on data source and not store data in local Power BI.

• Dual/Composite: Mixed between Import and Direct Query