Web Scraping Power BI Custom Visuals from Office Store
As promised here, today we will web-scrap Office Store website, and extract the information to build a catalog of Power BI Custom Visuals. You can share this...
Category: Power Query
Web Scraping In Power BI And Excel Power Query – Part 2 – Extracting links
As a follow up of the Web Scraping post, here, In today's post, we will use the Add Column by Example feature to extract links from web pages. (Note: You...
Get calendar with working days for any country in Power BI
An intro from Gil: Today we have a special guest on DataChant: Meet Ivan Bondarenko, an experienced analyst, and a fantastic Power BI blogger. Ivan will take...
Exploring the best of April update for #PowerBI Desktop
In today's post, I am going to be associative a bit, and explore the latest Power BI Desktop along several topics that I've wanted to share. We will cover the...
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...
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
Follow Me 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...
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...
Column Renaming and List.Zip To The Rescue – Pitfall #6 in #PowerBI #PowerQuery
Today, we will learn how to avoid the 6th pitfall as part of the Power BI / Power Query Pitfalls series. The sixth pitfall is quite tricky, and is one of the...
