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...
Tag: Power Query
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...
Complex Data Prep: Hawaii Tourism Analysis in #PowerBI
Better late than never. Prior to 2017 Power BI Data Insights Summit, Microsoft published here three challenges, including a complex data preparation. So, I...
Book Excerpt: Appending Worksheets from a Workbook
I am excited to share with you an excerpt from the draft manuscript of my book. You can pre-order the book in Amazon here. I expect to publish more excerpts in...
Power Query Transpose Bomb
Earlier in my days as a cyber security software developer, there was a term called Zip Bomb here, for malicious Zip files that were meant to consume excessive...
Signed a Contract to Write #PowerQuery Book
Dear Readers, Since I started DataChant on December 2015, and let Power BI and Power Query to slowly possess my professional life, I have firsthand witnessed...
Bulk Download of Power BI Custom Visuals
Update (Sep 24): Microsoft moved the custom Visuals to AppSource site. All my old queries to Office Stores cannot be refreshed, since Microsoft redirect the...
Bulk Download of Power BI Custom Visual Sample Files
Update (Sep 24): Microsoft moved the custom Visuals to AppSource site. All my old queries to Office Stores cannot be refreshed, since Microsoft redirect the...
Compare Tables in Excel & Power BI – Part 2
As a follow-up for the tutorial here, in today's blog post, we will show you how to use an improved version of the Table Comparison implementation, and apply...
