Unleash row level security patterns in Microsoft Power BI – Business Applications Summit
I was fortunate enough to be able to attend the Business Applications Summit in Seattle this year. I had an incredible time, met a lot of people that I have looked up to, read their blogs and watched their video’s. As well as made some new friends. One of the things that stood out for me was how easy it…
Review of new Features coming to Power BI by Oct 2018 – From Business Applications Summit
I was fortunate to attend my first ever Business Applications Summit in Seattle. I had the pleasure of sharing an Airbnb with Matt Allington, Phil Seamark and Miguel Escobar, it was great to spend time with these Power BI Legends. I also did meet a lot of people and got to chat with people in the Microsoft Power BI team,…
Using the Power Function.InvokeAfter to determine how long to wait between API calls
I have been working on a dataset which I will hopefully reveal soon, but part of that was that I was getting rate limited when making an API call. I found Chris Webb’s insightful blog post (Using Function.InvokeAfter() In Power Query) where he details how to use the Function.InvokeAfter. The one key piece that I personally found missing was how…
BI-RoundUp – Power BI (Service & Mobile Update – Create Power BI reports from Excel & CSV Files in SharePoint Online)
Here is the weekly BI-RoundUp, so let’s get into it Power BI – Service & Mobile Update As you can see above there now is an option to share a report with the current filter and slicers that are enabled. This is great because it will mean that you can have a subscription report that will send it out every…
Creating a Slicer that also contains a DAX Measure
I got an interesting question from Vijay asking, “How do we do a slicer with data count?” This is what Vijay was looking to achieve as shown below and I always enjoy a good challenge. As I always like to do, is to show how I got to the required result. I currently have got data from my website, which…
BI-RoundUp – Power BI (Developer Update for June – On-Premise Data Gateway Update for June – Securing your connection between Power BI & Azure SQL Database)
I must admit that I have been a little quiet with regards to my BI-RoundUp and it is partially due to being extremely busy working. As well as preparing for SQL Saturday Sydney and my presentation at the Business Applications Summit in Seattle at the end of July. As they always say, the show must go on, so here is…
Creating a DAX Calculated Column for Today, Yesterday and Next Working Day with Variables
Below was a question from the Power BI Community where the output was to have a calculated column in the Date Table, which would have Today for Todays date, Yesterday for Yesterdays Date, and Next Working Day (Being the following Monday) The challenge was that for the “Next Working Day” it should only be for the next Monday and not…
Power BI – Publish to Web to Remove Grey area on the sides
I was recently browsing the Power BI Forums, where I enjoy helping others with Power BI questions. Not only that, I also learn from other people in the community. In this instance I was unaware that Lukasz Pawlowski had created a really useful site where I could put in the page details for my Publish to Web page, which would…
How many times has my Power BI dataset been refreshed?
Have you ever wondered how many times your Power BI dataset has been refreshed? And if you are using Power BI Pro, you are limited to 8 refreshes a day. This week’s blog post I am going to demonstrate how you can use the Power BI API to view all your data refreshes for a particular dataset. If you need…
Power BI Infographic Update – June 2018
There have recently been quite a few changes and updates to Power BI, so in this blog post I have updated my Infographic. As well as put in references to where you can find more details on the updates that I have made to the infographic. Below are the relevant links Filter and Sort in the Data View in Power…