Would you like to insert Dynamic Text Values into your Power BI Text Boxes? As I was updating my CV dashboard (which I created for a contest a few years earlier), I noticed something unforgivable: I HAD HARDCODED A VALUE THAT WAS SUPPOSED TO BE DYNAMIC! This is an outrage! In my case, the hardcoded…
So you’ve created a wonderful instance method for your class. However, you would like to use the instance attributes created in that first instance method, in a second instance method WITHOUT calling the first instance method. In that case you can use the following inside your second instance method: self.first_instance_method()
Why does Power BI hate many-to-many relationships? Despite the title (that did its job in getting your attention) many-to-many relationships *-* are not necessarily evil. However, modeling your data in a manner that avoids many-to-many relationships helps in a lot of scenarios with data consistency, among other things. Let’s dive into this using the ancient…
You published a Power BI Semantic Model to the Power BI Service but it won’t refresh. It gives you the following error: “Information is needed in order to combine data. Please specify a privacy level for each data source.” One way you might solve this is: 1. Open the settings of the Semantic Model. 2.…
Searching a certain value in ANY column in a table has never been easier in Snowflake. Imagine you have an order number, and you would like to search for this order number in a whole bunch of tables that you do not know well. If you knew which column to search, this would be easy:…
Merry Christmas my dear network. Ready for some Python on Christmas day? Here we go. At the risk of kicking in open doors: don’t confuse the semantics of variable declaration in for-loops with functions. Variables that are defined in a function, are local to that function. They exist in the so called “local scope” of…
IMPORT DATA FROM A POWER BI SEMANTIC MODEL INSTEAD OF LIVE CONNECTION? Would you like to import data from a Power BI Semantic model instead of a having a live connection with the model? One way to achieve this is by importing the underlying Analysis Services model. This can be done by following the steps…
I remember reading about lazy evaluation for DAX variables the first time several years back in the book “The Definitive Guide to DAX” from Marco Russo & Alberto Ferrari. I also remember being very confused about the concept back then. It took some time and research in order to understand the concept a little better.…
Are you trying to reduce the runtime of your Python code? Faster code can reduce cloud costs, especially with serverless solutions like Azure Functions or AWS Lambda. One way to have your script run faster is by using so called “list comprehension” in Python. List comprehensions are a concise and often faster way to create…
Imagine you have to create a whole lot of measures in Power BI that are similar. One free way to do this is, is by using C# scripts in Tabular Editor 2.0. Below is an example of a “static” way to do this. You simply make the necessary adjustments like changing the table name and…
