Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod)
As I am sure a lot of people noticed if you now go into the settings of your dataset there is an additional option which says Parameters. What I wanted to test out was to see if I could change the connection strings using the Parameters in the Power BI Service. The advantages of this working in my opinion is…
Power BI – Using Parameters in Calculated Measures (Making Calculated Measures Dynamic based on Parameter)
What this is going to explain below is how I use a parameter that a user has entered to make a Dynamic Calculated Measure based on the Parameter entered. Example Scenario In my model I have got Parameters for the Fiscal Start Year So I want to create a calculated Measure that will get me the values for 4th Year…
Power BI Quick Tip – Using Parameters in Power Query Filters
I have been working lately quite a bit in Power Query and having to shape and re-create data based on the requirements. They had a requirement to make the data dynamic and immediately the Parameters in Power BI came to mind to create the solution. Now as we know using Parameters in Power BI has a lot of advantages. But one quick…