Handling Excel Formula Errors in Power Query

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...
Convert “Column1” to “A”

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

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...