The Potential Impact of #PowerQuery – A Crowd Wisdom Survey
Answer this short survey to estimate the potential business impact of Power Query. Once you answer the survey, you can scroll down to review the results below....
Category: Power Query
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....
Automatic Detection of Column Types in #PowerQuery
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...
May the 4th be with You: Be a Full Stack #PowerBI Jedi
If you missed my webinar in February, today is a great opportunity to watch it, and practice your Power BI skills with Star Wars...
#PowerQuery is Back!
It was a long weekend, and I am still working on the final chapter of the book. Taking the latest screenshots for the first chapter, Introduction to Power...
Book Excerpt: Loops, Recursions, Fibonacci and more from Chapter 9: M #PowerQuery
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
Webinar Followup: Be a Full Stack #PowerBI Jedi
In today's post, I am sharing a follow-up to my webinar, that will allow you to refresh the queries, and enjoy the support of scheduled refresh on Power BI...
Webinar: Be a Full Stack #PowerBI Jedi
If you missed my webinar today, here it is: https://www.youtube.com/watch?v=r0Qk5V8dvgg Download the solution file (.pbix) here. More resources: Star...
Split CamelCase headers in M (And a fix for the Record of Promises)
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name,...
Book Excerpt: Basic Text Analytics using Power BI and Power Query in Excel
Today I am excited to share a second excerpt from the draft manuscript of my book. Today's excerpt is the first part of chapter 11, which discusses basic text...
