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…
Why are my Power BI Persistent Filters Not Working – Quick Tip
I was recently testing out the new Persistent Filters in Power BI and initially it would work with some reports and not with other reports. I even looked at imported data models, vs DirectQuery/Live Connection reports and I could figure it out. So, I reached out to the very helpful people in the Power BI team, and they quickly showed…
BI RoundUp – Power BI (March Desktop Update, Share Content with anyone via email, Persistent Filters, Mixed Reality App, Service & Mobile Summary for Feb, Data & BI Summit)
After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door. Which means there is quite a lot to cover in this week’s BI-RoundUp. Power BI – March Desktop Update Once again, I must repeat what I have said before, the…
Walk through on sharing Power BI Content with Outlook.com (Hotmail, Live), Gmail.com by email
The sharing Power BI Content expanded further on 08 Mar 2018, where by you can now share content with email addresses such as Outlook.com or Gmail.com In this blog post I will walk through how this is done. I will demonstrate what it looks like for the user who receives the email, and ensure that they can log in and…
Power BI InfoGraphic Update – Mar 2018
There have recently been some changes to Power BI with regards to the new features which I will detail below. Which I also have updated in my InfoGraphic In the latest version of both Power BI Desktop and the Power BI Service, there now is the new capability to “Ask a question” and Sync Slicers. You can find more details…
BI-RoundUp – Power BI (Microsoft Leader in Analytics & BI – Push Apps to Users, On-Premise Data Gateway Update, Developer Update)
It is already the start of March, where has this year gone? I always look forward to the first week of every month when the imminent Power BI Desktop release is about to happen. But with that being said there are some updates already. Let’s dig in Microsoft Leader in Analytics & BI As you can see above, Microsoft is…
How to paste a screenshot/image into the Power BI Community Forum
In the past when I was answering questions I always had to get a screenshot, save it into an image and then upload the image. That was a real pain in the ……! I have to give full credit to fellow MVP Wyn Hopkins who made this discovery, you can find him on Twitter or LinkedIn How to paste a…
Dynamic Row Level Security is easy with Active Directory Security Groups
I am really excited to show you in this blog post how to use Active Directory (AD) Security groups to make Dynamic Row Level Security (DRLS) easy and simple. In the past when using DRLS there had to be a list maintained of all the users, along with what Row Level Security they required. As can be seen with the…
Power BI – Finding the data type when using Variables in Measures
I have been working with an Organization where I have had to create some rather complex measures. And within these measures I am using a fair number of variables. I found that at times it was a challenge to understand what data type was being returned by the variable. Which at times would lead to a different result, because the…
Power BI – One Measure dynamically made up from multiple measures (To show Month Estimate for current Month)
Where I am consulting there was a requirement where for the current month they wanted to display the Current Month Estimate for the current month they were in, and to show the historical sales for all the previous months. This makes some sound business sense, since currently month would typically start off with a lower sales amount, which would increase…