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...
Tag: Power Query
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...
Expand Table Column – Pitfall #9
It's time to expand table columns today, and get you acquainted with the ninth pitfall, which can be quite risky, as you'll soon find out. For those of you...
Split & Merge Columns – Pitfalls #7 and #8
In today's post, we will introduce the 7th and 8th pitfalls in Power BI and Power Query in Excel. To follow the pitfalls series, go here. The 7th and 8th...
