Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times
I was working for a customer recently, where the requirement was to create a slicer which would only show the data for Today, Yesterday and then all other days. When I was consulting with the other developers they were unaware that the Power BI Services Servers all have the Time zone set to UTC. And this applies to ALL Power…
BI-RoundUp – Power BI (Enterprise Capabilities for Power BI – Premium Click Through Demo – Campaign/Brand Management for Facebook – Power BI Report Server Roadmap – Understanding Power BI SKUs) – SQL Server 2017
With Microsoft Ignite happening this week there have been a whole host of announcements to Power BI which is great to see. So please read below for all the additional updates and details.
Power BI – Using OneDrive to Embed and Host Images for Power BI
I was recently on the Power BI Forums and I have seen a question before around where and how to host images that can be used within Power BI. I am going to show this with the example below. I am going to show you how to upload images to OneDrive, which can host your images for free. Then I will…
Power BI – Creating Dashboard or Report Email Subscriptions
I have seen a few questions asked in the Power BI Community Forum with regards to why people are not receiving their Email Subscriptions (Dashboard or Report). So I thought it would be best to create a quick blog post to hopefully help a few people. So below I will show how to create the subscription as well as some…
BI-RoundUp – Power BI (Desktop update for September – Service update for August – Filters coming to iOS App – How Feedback influences Microsoft Business Applications Development)
This is the weekly update in the world of BI Power BI – Desktop update for September We now have got the September release of Power BI Desktop and there have been almost all of the updates in the reporting area within Power BI Desktop, so as I do with every monthly update I will give an overview below. Reporting…
Power BI – Creating Text based on TOPN values from Filters ordered by measure value
When I was working on the What-If contest, one of the requirements that I wanted to add was text based details. But the kicker was that when I put the text values into a measure it was showing the values, but based on an alphabetical order instead of being based on the numerical values. One challenge for me was to…
BI-RoundUp – Power BI (Drill Through coming… – Timeline Storyteller Competition)
TimeTimeTHere is the weekly BI Roundup Power BI – Drill Through coming – Already in the Power BI Service As you can see above the Power BI Team has already enabled the Drill Through functionality into the Power BI Service. This is something that was seen at the Microsoft Data Insights Summit and it is here. I think that this…
DAX – Filtering Measure to show value when selected or no values selected
I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want the value to be displayed. I did this so that when the users are using the report, it will clearly…
BI-RoundUp – Power BI (User details in Usage Metric Reports, Power BI Report Server Aug Update – Timeline Story Teller Custom Visual)
Here is the weekly BI Roundup of what has been happening in the last week. Power BI – User details in Usage Metric Reports As you can see in the image above, the Power BI team has now incorporated the capability to see which users have been accessing the reports. This is really awesome because it not only allows you…
BI-RoundUp – Power BI (On-Premise Gateway Update August – What If Competition – Solution template for Microsoft Dynamics 365)
Here is this week’s BI Round up with the latest weekly information. Power BI – On-Premise Gateway update for August As you can see above in the August update there is now support for IBM Netezza connector the new TLS format 1.1 and 1.2. It is also good to see that they have increased the timeout for gateway requests from…