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...
Category: Power Query
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...
Bitcoin What-If Calculator & Regulation News in Power BI – Detailed Version
Some people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is a Power BI tool to play with different...
Bitcoin What-If Calculator in Power BI
Many people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is your best Power BI tool to play with...
