Define top events in DAX for your Pulse Chart in Power BI
As I was working on the Presidential Facebook Reaction Dashboard here, the Power BI team have announced the release of the Pulse Chart. Excited by...
Iterate over dynamic Web API Pages with Power Query – How to resolve Cursor-Based Pagination
In today's post, we will go over an advanced Power Query technique that will help you to import data from Web REST APIs that implement Cursor-Based...
Facebook Post Reactions to Trump and Clinton in Power BI
How many likes do Clinton and Trump receive? Who gets more Angry, or Sad reactions on their Facebook pages? What is the most exciting post that yield Love or...
Privacy Bug in LinkedIn API – Demonstarted with #PowerQuery #Excel and #PowerBI
Inspired by the big news that Microsoft is about to acquire LinkedIn here, and due to my past history as a privacy and security advocate in Microsoft Excel...
Analyze Facebook Reactions with Power BI
Earlier this year, Facebook introduced the new reactions Love, Haha, Wow, Sad and Angry. In my blog post here, I shared with you the implications of the...
How many Facebook friends congrat me on birthdays – Find out with Excel Power Query
I know that this is not one of the most important questions to ask, but inspired by my recent birthday, I am sharing this workbook that answer the following...
Faster Matrix Mulitplication
As a followup for our recent Matrix Multiplication post here, I would like to share with you a faster query for Matrix Multiplication (Faster only relative to...
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...
