Power BI – Gateway Infographic
Following on from my previous Power BI Infographic blog post, I also have had the idea to create an Infographic for the Power BI Gateway. This came about after reading the blog post by Kasper De Jonge Enterprise gateway sizing “recommendations”, and there was a lot of valuable information which I have put into the Infographic as well as detailed…
BI-NSIGHT – Power BI (Granular Tenant settings, Amazon Redshift connectivity in Power BI Service, Featured Data Stories, Availability Monitoring Publish to Web) – Excel (Get & Transform updates) – SQL Server (DAX support in Report Builder and SSMS)
Here are the weekly updates. Power BI – Granular Tenant Settings I can personally say that I know a few of my clients who are very happy that the Power BI team has already implemented the Granular Tenant settings for Power BI. I have to say that I am once again impressed by the Power BI Team really a great…
Power BI Query Editor – Getting IP Address Details from IP Address
I recently had a question from a user in the Power BI Community page who wanted to know where the people were coming from based on their IP Address. The IP addresses were stored as part of the dataset, but to try and go and do this with the IP Address database meant that you would then need to go and…
Power BI – (March Desktop Update, Theme’s Generator, Esri New Technology Integration Award, K2 Process Content Pack, Advanced Search Solution Template, Project Service Automation for Dynamics 365 Solution Template, New Custom Visual 3D Pie Chart)
There has been a whole host of updates to Power BI in the past week which is great to see, so I hope that you enjoy reading this as much as I enjoyed putting it all together. Power BI – March Desktop Update In this month’s updates there are a whole host of great updates, and the Power BI Team…
Power BI – Power Query/Query Editor Automated Source Control
I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quick and easy manner. So below is how I achieved this. My solution below, uses a BAT file and 7zip, which means…
BI-NSIGHT – Power BI (Mobile Apps Update Feb, Connecting from Power BI Mobile to SSRS, Embedding Power BI Reports)
As another month comes to a close, I am excited to see what the next week will bring. Hopefully some updates for Power BI Desktop and the service. Here is this week’s roundup. Power BI – Mobile Apps Update for February In this month’s mobile update they have made some additional actions when interacting with the Dashboard tiles on the…
Power BI – Creating a Calculated Table which holds a particular single value
I was working on a Power BI Model where I had a requirement where I wanted to use the Last value from an [Actuals] calculated measure as part of another calculated measure [Pro-rata Budget Selection]. Now due to the way the filter context works, when I tried the following calculated measure below, it would return the value where the Fiscal Quarter was Q4,…
BI-NSIGHT – Power BI (Garnet Magic Quadrant)
It has been a great week in the world of Microsoft BI, with the release of the Gartner Magic Quadrant and how well Microsoft is doing in this space. Other than that, nothing else to report on this week. Power BI – Gartner Magic Quadrant As you can see from the image above Microsoft is leading as a Visionary as…
Power BI – Infographic for Power BI from an end to end perspective
So for a bit of a change, this blog post will not have a whole lot of technical details, but instead I wanted to share something that I have been working on for quite some time. It is an infographic for Power BI from an end to end perspective. I have found this very useful when chatting to people about…
BI-NSIGHT – Power BI (Data Insights Summit 2017, Integrate Reports into SharePoint, Dual KPI, Featured Data Stories, Apply Filters to your report per User, Grid Custom Visual)
There have been some really great updates coming out especially from the Power BI team in the past week. So let’s get into it. Power BI – Data Insights Summit 2017 I can remember that the Data Insights Summit of 2016 was a great success and heard some great content and really deep dive information was shared at the summit….