Importing data from external sources with Power Query directly into a Pivot Table in Excel

preview_player
Показать описание
When all you need is a pivot table report from data from external files your sources, you can do it without the need of bringing the data physically into the Excel file that contains the pivot table. Learn how.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

________________________________________________________

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
___________________________________________________________________

Twitter: @celia_excel

Instagram: @solveandexcel

#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

-------------------------

#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada
  1. Celia Alves - Solve & Excel
  2. excel
  3. msexcel
  4. power query
  5. canada
  6. solveandexcel
Рекомендации по теме
How to Easily 0:11:16

How to Easily Import External Data into Excel & Import Data from the Web

Importing External File 0:06:05

Importing External File Data into Microsoft Excel

Importing data from 0:03:13

Importing data from external sources with Power Query directly into a Pivot Table in Excel

Importing Data From 0:01:22

Importing Data From External Sources

ArcGIS Online: Importing 0:04:36

ArcGIS Online: Importing Data from External Sources

Easily Import Data 0:10:02

Easily Import Data from Web to Excel (2 Practical Examples)

Part 13: Importing 0:10:09

Part 13: Importing Data From External Sources | Excel Advanced

R Podcast Episode 0:54:04

R Podcast Episode 6: Importing Data from External Sources

How to Create 1:09:35

How to Create a Block Scaffolding Tool in WordPress | Technical Guide

Import data from 0:00:49

Import data from a Web page in Excel

Importing Data from 0:05:15

Importing Data from Excel to Microsoft Access

Importing from an 0:04:09

Importing from an External Data Source

Excel 2013: Importing 0:02:36

Excel 2013: Importing Data from various Sources

How to Import 0:06:49

How to Import Data from Web to Excel

07 - Import 0:08:53

07 - Import Data from an Another Excel Workbook using Power Query

MS Excel - 0:09:21

MS Excel - Import Live Data From Web to Excel

How to import 0:09:28

How to import data from Microsoft Excel into Microsoft SQL Server

Importing External Data 0:08:11

Importing External Data Into Excel on Mac // Excel Tutorial

How to Pull 0:08:27

How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets?

Importing External Data 0:12:04

Importing External Data Sources into the Power Pivot window

Import Data into 0:05:16

Import Data into R Studio

Importing Data from 0:04:22

Importing Data from a Text File to Microsoft Access

Power BI Get 0:08:31

Power BI Get Data: Import vs. DirectQuery vs. Live (2021)

82 Importing Data 0:05:01

82 Importing Data from REST APIs | Other Data Sources | Power BI

Комментарии
Автор

Now when I run a Query, Option does not show me that I am loading the data as a pivot table. I have to load the table and then make it pivot. Does this need to update my Excel or is this option locked and needs to be opened?

nermeenrezk
Автор

Great video, thank you very much. Is it possible to import an external power query (without loading a Tabelle before) into an existing power pivot model?

francescopalma