Are you collaborating with multiple Analytics Engineers on the same dbt repository? In the following hypothetical setup, dbt is used to load data into Snowflake, and Power BI is used to create reports based on that data. Each engineer has their own schema when developing and deploying locally, following dbt best practices. In Snowflake, this could look…
Do you want to implement certain business logic in multiple measures or calculated columns in your semantic model and maintain that logic in one place? With User Defined Functions in Power BI you can do just that. Your own custom functions, reusable across the entire Power BI Semantic Model in measures and calculated columns. It’s…
Ever wanted to know what the data source is for a DirectQuery table in your Power BI composite model? I have not found an easy way to check this. Using Tabular Editor however, it can be done. Follow the steps below. Open tabular editor → connect to the semantic model you want to inspect →…
In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a measure containing the function CALCULATE in Power BI. In the image below we use a measure without the function CALCULATE. Zooming in on the RunningBalanceMeasureNoCalculate value of “1300” in the screenshot below: the first three rows adhere…
In the last post we calculated the running total of bank account transactions (withdrawals and deposits) using a calculated column in Power BI. In the image below we use a measure with the function CALCULATE. Zooming in on the RunningBalanceCalculate value of “1300”. The first three rows adhere to the filter condition “<= _Date” and…
Calculating running totals is a must-have for many business reports — but did you know there are several ways to do it? I’ve tested multiple methods, each with its pros and cons, and I’m sharing my learnings with you in this carousel. 👉 Swipe through to see each approach explained simply, and let me know…
Are you working with Power BI and Snowflake? Would you like to know what queries Power BI sent to Snowflake? Sometimes you want to know what exactly is happening between Power BI and Snowflake. Perhaps you want to know how costly a certain load from Snowflake to the Power BI Service is. Or maybe you…
A Python script in an Azure Function is used to retrieve data from a REST API. Azure Data Factory is used for orchestration. The Python script is also used to transform and append the data. Transformations included parsing nested JSON files and applying business logic by e.g. adding descriptive columns. The result is several fact-…
Ever wondered how to do a Multi-Column-JOIN in Power Query M? It is so simple to join TABLE_A to TABLE_B in SQL using multiple conditions on multiple columns: But how do we replicate this in Power Query M? Turns out we can add a column using the Power Query M function Table.SelectRows. Take a look…