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….
Power BI – Getting your report to always filter this month’s data dynamically
I had a requirement where I needed to have the capability to set the filter once on a report for the current month and then it dynamically move as each month progresses. I will show how I completed this in the steps below. NOTE: As with almost all Power BI Models, this is going to be leveraging off my Date table…
BI-NSIGHT – Power BI (February Desktop Update, iOS Mobile App with Q&A, Dual KPI Custom Visual, PowerApps Common Data Service) – Excel (Get & Transform Updates for January)
I had to re-write this, as I had a suspicion that the Power BI Desktop would be released soon and here it is, along with other updates. Power BI – February Desktop Update This Power BI Desktop update is here, and I have to say that there are some awesome additions and new improvements. So I will highlight below what…
Power BI – Why creating columns in the Query Editor is better, quicker and more efficient than creating Calculated Columns.
I have been reading and helping out where I can on the Power BI Community forums. And what I often see is people trying to use the Calculated Columns in the Power BI Desktop Model. So in this blog post below I am going to explain why it is better, quicker and more efficient to use the Query Editor to create additional columns….
BI-NSIGHT – Power BI (January Service Update, Push data to Power BI Streaming, Mobile Apps update Jan 2017)
I cannot believe that is already February which means that really soon there should be the next Power BI Desktop release. Here are this week’s updates, which I hope you will find informative. Power BI – January Service Update There are quite a few service updates this month with some of them being more for the monitoring and administration of…
BI-NSIGHT – Power BI (Tachometer Custom Visual, Azure Active Directory Content Pack, ZynBit using Power BI Embedded) – SQL Server (CTP 1.2 Available)
There has been some great activity this past week in the world of Business Intelligence and here are the updates. Power BI – Tachometer Custom Visual As you can see from the image above, there is a new Custom Visual that has been added called the Tachometer. This is a great visual when you want to use it to easily…