BI-RoundUp – Power BI (Working with PowerShell in Power BI – Deprecation of Custom Visuals API 1.1)
Here is the weekly BI-RoundUp and at least this week it will be a quick read! Power BI – Working with PowerShell in Power BI I am not going to go into great detail here, due to Kay giving a detailed explanation how to use the PowerShell cmdlets. What I will say is that after reading through the above blogpost…
Quick Tip Adding Search to the Default Slicer in my Power BI Report
I always am amazed that there is still so much to learn with Power BI. This week’s blog post is short and sweet, I am going to demonstrate how to add searching to the Default Slicer in my Power BI Report. The main reason that I required this, is because currently (14 Aug 2018) the persistent filters only works with…
BI-RoundUp – Power BI (Desktop Release for August – New App Workspace Experience – Power BI World Tour) – Analysis Services (White Paper for AS Scalability)
Here is my weekly BI-RoundUp, and as I thought when I started putting this together yesterday that there would be a release of Power BI Desktop, which there is and not only that an updated App Workspace experience! Enjoy the read! Power BI – Desktop Release for August Well that was pretty quick to get another release of Power BI…
Convert from Seconds to Minutes with a DAX Measure
I was recently doing some consulting work for a customer and they had a column which contained seconds and whilst this is useful it is better to have it shown as Minutes and Seconds, which is easier to relate and compare. Below I will show you how I came up with the DAX measure which converts it from seconds to…
BI-RoundUp – Power BI (July Desktop Update – Admin APIs & PowerShell for Power BI – Multi Geo Support for Power BI Premium – Power BI & SharePoint – On-Premise Gateway Update for July – Developer Update for July)
Since the Business Applications Summit there has been a whole host of updates to Power BI, so please find all the details below. NOTE: This is once again a longer read with just so many updates that have come through. And it is well worth the read. Power BI – July Desktop Update As with every month I will highlight…
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…