BI-RoundUp – Power BI (Choosing the best licensing for you and your Organisation – On-premise data Gateway Update – Developer Community Update – Duplicate Workspaces using the REST APIs
Here is the weekly BI Roundup Power BI – Choosing the best licensing for you and your Organisation In this blog post from the Microsoft Power BI team, they go through the different licensing options that are available. They also go through the differences between Power BI Pro and Power BI Premium. As well as give some answers to the…
Power Query – How to get same row number for x number of rows
I was answering a question on the Power BI Community Forum where a user was looking to get some data from an Excel spreadsheet into Power BI. And in order for me to complete it, I wanted to get the same row number for x number of rows. Example I had some sample data where the same data was repeated…
How to use Bookmarks in Power BI for Seamless Report Navigation
In the latest update of Power BI Desktop, there now is the capability to be able to use Bookmarks. What bookmarks does is allow you to create an informative way in which you can tell your story. It really is an awesome feature and something that I know a lot of people have been asking for. If you want more details…
BI-RoundUp – Power BI (October Desktop Update – Update for Power BI Service & Mobile – Email Subscriptions for Apps – AI recommendation for Apps)
As with every month it is with great excitement to see what updates there are to Power BI. I have also included any other related Business Intelligence updates. Enjoy the read Power BI – October Desktop Update There have been a whole host of updates to the Power BI Desktop, and here are the relevant details below. Reporting The biggest…
Using Power BI to ensure Daylight Savings Dates and Times change dynamically
I was helping on the Power BI Community and it struck me that there currently was not a way to easily manage Dates and times for Daylight savings. In this blog post below, I will show how I achieved this by using parameters and little bit of M magic (Directly Editing the M Code). As part of completing this solution I…
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…
BI-RoundUp – Power BI (On-Premise Sept Update – Developer update for Sept – Congrats to What-If Winners – Custom Connectors in Action – Timeline Storyteller custom visual contest)
There have been quite a few updates in the past week, so please find all the related updates below, of which there have been quite a few! Power BI – On-Premise Sept Update In this month’s update for the On-Premise Gateway they have added support in the Personal mode for national clouds. There has also been a great improvement in…
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…