Select Page

#PowerQuery Book Update – Table of Contents

In today’s short post, I would like to share with you the Table of Contents of my book, Collect, Combine and Transform Data Using Power Query in Excel and Power BI. (You can pre-order the book on Amazon here or on Microsoft Press Store here). This post first appeared...

Microsoft MVP Award 2018-2019

I was excited and humbled tonight to receive this special email from Microsoft: Dear Gil Raviv, This post first appeared at https://datachant.com/2018/07/01/microsoft-mvp-award-2018-2019/. The author is Gil RavivRead...

Happy Birthday and #PowerQuery Book Update

I am celebrating my birthday today, so I wanted to share with you a quick update about my book. It is now in production. You can already pre-order it here. Current release date is September 4, 2018. Follow @gilra This post first appeared...

Automatic Detection of Column Types in #PowerQuery

Follow @gilra Working with column types can be challenging in Power Query. The default conversion of types may not always work well for you, and may create future refresh errors, when the column names change. I have blogged about it in details here, and usually...