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:
Imke Feldmann, [ Ссылка ]
Wyn Hopkins [ Ссылка ]
Ken Puls [ Ссылка ]

Ken Puls' blogpost on the Formula.Firewall error:



For an intro to Power Query here's my Lynda.com course:
[ Ссылка ]


Website: [ Ссылка ]

My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]

My old blog: [ Ссылка ]

свернуть