Analyze Public Facebook Groups in #PowerBI
Whether you are a social media addict, or a Power BI analyst, here's is a common question you always wanted to answer - Who gets the highest number of likes in...
Category: Power Query
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...
#MSDataSummit Ten Pitfalls of the Data Wrangler using Power BI
Meet Alice the Power BI Data Wrangler, and DBA Bob, and learn how Alice can survive the 10 pitfalls when there is no proper data contract with Bob. Here is...
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...
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...
