Facebook Insights Bug
If you use Excel and Power BI Facebook connector to read page insights, you should be aware of this recent bug. Till it gets fixed, you cannot read most of the...
Nested Loop with List.Generate in Power Query
Recently I shared a Matrix Multiplication Power Query technique here, and explained how to use List.Generate as the core step of the multiplication. It was...
Power Query List.Accumulate – Unleashed
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...
Excel Matrix Multiplication – Replacing MMULT with Power Query
In my last Thank You post, I suggested that Matrix multiplication is not Excel's forte. Following that post, I got a cool Power Query solution from Imke...
DataChant is 6 month old
Thank you for following my blog. I wanted to write something personal today to celebrate the blog's 6 month milestone. I started this blog 6 months ago after...
Analyze Linkedin Company Page with Excel and Power BI
Update: LinkedIn restricted the use of the company search APIs. You need to be a LinkedIn partner to be able to follow this article. Your company's page on...
Linkedin Company Search with Power BI
Update: LinkedIn blocked the use of their APIs to partners. This report cannot be implemented, if you are not a partner. Today I wanted to share with you a...
May the 4th Be With You and Power BI
For the fans of Star Wars, you might have already stumbled upon my previous post: Star Wars – The Power (BI) Awakens, so today for the special occasion of...
Power BI Templates
Microsoft released today (29 April, 2016) a new update of Power BI Desktop with some new cool features here. In particular, I find the new Power BI templates...
Watch our webcast at PASS Excel BI Virtual Chapter
Hi everyone, If you missed our post here, or want to refresh your skills on Excel, Power Query and analysis of Facebook Page Insights, check out our...
