Power Query Transpose Bomb
Earlier in my days as a cyber security software developer, there was a term called Zip Bomb here, for malicious Zip files that were meant to consume excessive...
Tag: Power Query
Signed a Contract to Write #PowerQuery Book
Dear Readers, Since I started DataChant on December 2015, and let Power BI and Power Query to slowly possess my professional life, I have firsthand witnessed...
Bulk Download of Power BI Custom Visuals
Update (Sep 24): Microsoft moved the custom Visuals to AppSource site. All my old queries to Office Stores cannot be refreshed, since Microsoft redirect the...
Bulk Download of Power BI Custom Visual Sample Files
Update (Sep 24): Microsoft moved the custom Visuals to AppSource site. All my old queries to Office Stores cannot be refreshed, since Microsoft redirect the...
Compare Tables in Excel & Power BI – Part 2
As a follow-up for the tutorial here, in today's blog post, we will show you how to use an improved version of the Table Comparison implementation, and apply...
Compare Tables in Excel & Power BI
Do you often find yourself in dire need to compare two tables in Excel? In today's blog post, we will create an Excel workbook that compares two tables, and...
Web Scraping in Power BI and Excel Power Query
There are abundant public data sources on the Web, and it is so tempting to import and mash them up with your existing data sets in Power BI and Excel Power...
Protected: Subscriber’s Resource: Bypass Web Proxies – Sample Query
This content is password protected. To view it please enter your password below: Password:...
Text Obfuscation in Power BI and Power Query in Excel
Power BI and Excel offer a wide variety of collaboration and sharing experiences. In today's blog post, we will share a useful method to easily obfuscate /...
Remove Duplicates, Lookup Tables and Pitfall #10 in #PowerBI and #PowerQuery
In today's post, we will learn about the tenth pitfall in Power BI and Power Query in Excel (Read all pitfalls here). For this special occasion, we'll get...
