Select Page

Compare data in Excel with Power BI

Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? Would it be awesome if you could do it without the need to open the files every time? In 2021, we released a Power BI app, called Excel Compare. Due to its high demand...

Authoring a Power BI Dataflows Solution

Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring experience, some important considerations, basic architecture, and Do’s and Dont’s. Options to create tables This...

Introduction To Power BI Dataflows

For my first blog post I wanted to write about one of my favorite topics: Power BI Dataflows. If it’s the first time you read about this product or if it’s a product you have been trying to learn more about, this is meant for you. What Are Power BI Dataflows? This...

Next Chapter

I have been quiet for a while and had a lot of thinking about my next chapter after leaving Avanade last August. Today, I would like to share with you a small bit of personal news, but more importantly — a major update about DataChant’s next chapter. Since 2013, when...

My Power Query Book in Russian

Follow @gilra Here is a quick update for my Russian friends and colleagues. My book “Power Query в Excel и Power BI: сбор, объединение и преобразование данныхis” is available here. This post first appeared...