power-query

Introduction Click here to go straight to the function. *Disclaimer* this function is not the most exciting but is used in a few other more exciting functions I plan on sharing. Sometimes when performing transformations in Power Query, data types are lost, e.g., when unioning two tables and columns with the same name have different Continue reading

Introduction Click here to go straight to the function. When importing data from a database, column names are often stored in camel or pascal case because of the challenges/inconveniences spaces can cause. While it is best practice to avoid spaces in SQL column names, I prefer storing Power BI column names in proper case because Continue reading

Introduction Click here to go straight to the function. One of the key (pun intended) aspects of dimensional modeling is the creation of surrogate keys in your dimension tables. A surrogate key is a column generated to serve as the primary key of the dimension in lieu of the natural key. There are many reasons Continue reading

Introduction Click here to go straight to the function. If you are doing any type of dimensional modeling in Power BI using Power Query, you are probably very familiar with the “Merge Queries” button that helps the user join two tables together. Although the GUI is very useful, the resulting code may not be as Continue reading