Import from a Specific Folder with Power Query ... and that Formula.Firewall Error

preview_player
Показать описание
Importing data from a folder in Excel's Power Query is easy. But what if you want to use a dropdown list to select and import from a specific folder? It involves passing a parameter (as we've done in previous videos) and a little M code.

This video shows 2 methods and addresses the mysterious error:
Formula.Firewall: Please Rebuild This Data Combination

The first method involves telling Power Query to ignore privacy levels.

The second method shows how to respect the privacy levels and still get Power Query to cooperate. There's some M coding involved but not too much.

Thanks to the following people for their help:

Ken Puls' blogpost on the Formula.Firewall error:

My book: Guerrilla Data Analysis 2nd Edition

  1. Excel On Fire (Oz du Soleil)
  2. Formula.Firewall
  3. Power Query Formula.Firewall error
  4. Import from a folder using Power Query
  5. Oz du Soleil
  6. dropdown lists in Excel
Рекомендации по теме
Import from a 0:10:12

Import from a Specific Folder with Power Query ... and that Formula.Firewall Error

Python - Importing 0:07:01

Python - Importing your modules (Part 2: Import from a different folder ~7 mins! no ads)

Python – Different 0:15:52

Python – Different Ways To Import Module From Different Directory

Import All Excel 0:08:01

Import All Excel Files from a Folder in PowerBI | Power Query | MiTutorials

Python Import Function 0:06:06

Python Import Function From Folder | Python Tutorials | SavageCamp

Import Data from 0:15:29

Import Data from Multiple Excel Files from a Folder using Power Query

How to Import 0:07:04

How to Import Emails From OUTLOOK to EXCEL & why you want to do that!

How to Import 0:08:25

How to Import Data from multiple files in a folder in Alteryx

Descript 101 1:31:49

Descript 101

In python how 0:06:04

In python how to import & access multiple files from a folder

Import modules in 0:18:41

Import modules in Python | Import module from different directory | Python Tutorial for beginners #5

The best way 0:08:44

The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh

Import ONLY The 0:09:25

Import ONLY The Latest File - Power Query

Great Power Query 0:00:57

Great Power Query Tip ▶️ How to Import Entire File Content in Excel or Power BI #shorts

Alteryx: How to 0:24:31

Alteryx: How to Import Multiple Different Excel Tabs, Files, and Schemas At Once (No Schema Errors)

How to Import 0:05:07

How to Import Multiple CSV Files into Separate Worksheets in the Same Workbook in Excel

Power BI Tutorial: 0:12:56

Power BI Tutorial: Import Files from a Folder into Power BI Desktop

TOO MANY EMAILS? 0:13:16

TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included

Excel VBA To 0:09:55

Excel VBA To Open & Import Last Created/ Most Recent Workbook in Folder

07 - Import 0:08:53

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

InDesign Tutorial - 0:08:55

InDesign Tutorial - Import a folder full of pictures, one per page

How to import 0:02:33

How to import multiple files from a folder in Matlab?

How to import 0:02:35

How to import all CSV files from folder into one Pandas DataFrame (Python)

014. Import Data 0:08:13

014. Import Data from MULTIPLE PDF into Excel with Power Query! (no 3rd party software needed)

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

Hi Oz, When I am in really Deep trouble - you always have a way forward

Zealand-Data
Автор

Digging the single solution - I would suggest using the Index reference by using {0}[Club] within the concatenation to save yourself a few within the applied steps.

Source = & Excel.CurrentWorkbook(){[Name="Table1"]}[Content]{0}[Club]),

ItsNotAboutTheCell
Автор

Lately I've been trying to make as few queries as possible.
add couple new steps starting with = Excel.Workbook(), then just reference it in subsequent steps
much more compact and less troubles

ViktorParkhomets
Автор

Nice examples....and thanks for reminding us to not mess with geese!

DougHExcel
Автор

Thanks for the Colorful Data Import M Code fun!!!

excelisfun
Автор

Can't thank you enough for that. It was driving me nuts

garyallan
Автор

Hi OZ, I really like to know how to create a drop down list that contain folder names and once you refresh the data the only folder contain refreshed. I don't know the process could you please assist me from where I get to learn the process. Is it done using power query?
Thank you for the video.

syedtalhamanzar
Автор

wow, amazing trick. you rocked again man.. many thanks for sharing

"Transform File from Orange’ query. Expression.Error: The key didn't match any rows in the table".

Can you please help on this error when i press refresh preview?

entertainmentgalaxy