GitHub as Storage

I have increasingly found myself searching through older .pbix files looking for a handy function that I DO NOT want to rewrite. Both the looking for and the rewriting of functions are laborious, frustrating, and above all, unnecessary endeavours. By using her extremely helpful Curbal vlogs, Ruth Pozuelo pointed me to a (now obvious) solution: … Continue reading GitHub as Storage

Power BI Specialist is…

As mentioned in a previous post, I attended my first London Power BI User Group meeting last week. The presentation given by Reza Rad was titled Dataflows vs Datasets, but covered somewhat more. Data Architect ... Data Analyst ... Data Engineer... In addition to the expected comparison of dataflow and dataset definitions in the context … Continue reading Power BI Specialist is…

More on M

A recent post demonstrated the succinct and powerful quality of code native to Power Query. The original conundrum is highlighted in the Power BI forum here, and the posted solution no doubt works, but is a little cumbersome. The Power of M lies in it's human readability, which not only does not require encyclopaedic knowledge … Continue reading More on M

The Power of M…

...Power Query M WARNING: convoluted geek joke ahead Three data analysts walk into a bar, and the bartender gives them a problem: "My data table includes a column containing Company Name, but I want the business acronyms in a new column, with a space between each initial. Oh, and the data contains some hinky characters … Continue reading The Power of M…