Select Page

Handling Excel Formula Errors in Power Query

Follow @gilra Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and errors. To implement the app I needed to resolve key obstacles that are very common when you import Excel...

A New Journey

This Friday was my last day at Avanade. It was an amazing journey for me and I would like to deeply thank many people at Avanade for the inspiration, friendship, and wonderful experience over the last 5 years. Avanade was a great home and a family for me. I started as...

Mailchimp App: New Features

This week we released a major update to the Mailchimp app on AppSource here and included 5 new report pages. Get latest version This post first appeared at https://datachant.com/2021/08/10/mailchimp-power-bi-app-update/. The author is Gil RavivRead...

Convert “Column1” to “A”

Follow @gilra I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI app that we released on AppSource earlier this week, and you can consider reading this post as a...

Excel Compare: Audit your workbooks

Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? We have just released our 10th app on AppSource that can help you achieve it. Excel Compare (available on AppSource here) is a free Power BI app that compares two Excel...