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…
BI-RoundUp – Power BI (February Update, Data.World Connector)
There has not been a lot happening in the past few weeks, but I am delighted to have another blog post with the latest Power BI updates. Power BI – February Update As I do every month I will go through in fairly light detail the new features in Power BI. And there are some fantastic new features. Reporting 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…
BI-RoundUp – Power BI (Developer Update – Balanced Scorecard – Deep dive at Data & BI Summit Ireland – Difinity Conference)
Here is the weekly BI-RoundUp, lots of great things happened in the past week! Power BI – Developer Update There is now a developer update for Power BI Developer, and there are a whole host of new updates for the Power BI Developers. I will give a brief overview of each section and if you want more details please click…
Power BI – Losing Disk space when working with Power BI Desktop
I recently had an issue on a customer’s server, where I was developing Power BI Desktop reports. And the C: Drive was running out of disk space, which was attributed to my user profile. Upon inspection I found that the TempSaves directory had a whole stack of temporary files saved in there. Even though I had previously selected to change…
BI-RoundUp – Power BI (January 2018 Update – Power Apps Custom Visual)
Welcome to 2018, and I am sure that everyone is keen and ready to hit the ground running. I am really excited to see what this year will bring, both personally as well as with how things progress specifically in the Microsoft BI (Data and Analytics space). So here is my first BI Roundup for 2018 Power BI – January…
Ask a Question (Q&A) Hidden Treasures in Power BI Desktop
The new Ask a Question (Q&A) in Power BI Desktop really does make it quick and easy to create new visuals. Here is a link to the blog post from the Power BI Team: Q&A for report creation (preview) I have been using Q&A in the Power BI Service for some time, and there are a few hidden treasures that…