I recently moved a site from wordpress.org to wordpress.com.

I was hosting the site on my server, but as it reached (sometimes) 800 visitors a day, it took too much of the server capacity, so I decided to move it. As I am not monetizing the site, I moved it to wordpress.com.

During the move, something went really wrong and all my images’ URLs got broken. The site was live but no images to show and as this is a how-to site, without the pictures, well..., half the value was gone. In wordpress.com it is not possible to access the database, so I was stuck.

Here is how Power Query came to the rescue and saved me tons of hours of meaningless updating. Read on to find out how!

Power Query and DAX have limited looping capabilities. And by limited, I mean almost non-existent. However, Power Query does have one looping method that can be used to solve a variety of problems, recursion. This article demonstrates how to leverage Power Query's recursive capabilities to solve a particularly vexing issue in converting hexadecimal values to decimal values. This same technique can be used to solve a variety of challenging data import and conversion issues.