Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)

Опубликовано: 30 Август 2018
на канале: excelisfun

37,724

749

Learn how to deal with Power Query Error: Formula.Firewall: Query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Two solutions are presented in this video.
Download Files: Excel Start: https://people.highline.edu/mgirvin/A...
Zipped Folder: https://people.highline.edu/mgirvin/A...
Download Excel FINISHED Files: https://people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/A...
Assigned Homework - these are problems for you to practice your new M Code skills:
Download Excel File with Homework: https://people.highline.edu/mgirvin/A...
Example of Finished Homework: https://people.highline.edu/mgirvin/A...

Chris Webb’s blog about this topic: https://blog.crossjoin.co.uk/2017/06/...
Ken Puls blog about this topic: https://www.excelguru.ca/blog/2015/03...

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.