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: Popular
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...
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...
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...
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...
Removing/Selecting Columns – Pitfall #5 in #PowerBI and #PowerQuery
In today's episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when...
Common Data Patterns You’ve Never Dared to Transform – Global #PowerBI Webcast
If you have missed my webcast on Global Power BI User Group, you can now watch the recording, and download the Power BI files (details...
