Nov 2017 Update to Power BI Overview Infographic

There has been quite a few changes and updates since I last reviewed my Power BI Overview Infographic. I thought it was time for an update, and here is what has been updated.

Please feel free to share this with other people new to Power BI, or people who want to get a more general feeling of all the moving parts in Power BI.

Here is a link to where you can find the Power BI Overview InfoGraphic as well as what the main page of the Infographic looks like.

Bookmarks

The bookmark feature has been blogged about quite a lot, and it is a great edition to enable better story telling using Power BI.

You can find details about bookmarking here: Use bookmarks to share insights and build stories in Power BI (Preview)

Selection Pane

The selection pane allows you to control if an item in your report will be made visible or not visible (Invisible maybe!)

It is also a great way when there is a lot of items on your report page, to select the item from the Selection Pane, which will then have it selected for you.

You can also use to show or hide items from the Selection Pane as part of your Bookmarks, so you can make it appear as if items are moving or vanishing from your report.

The Power BI team has already made some improvements by allowing you to order the items in the Selection Pane.

You can find more details here: Power BI Desktop Oct 2017 – Selection Pane

Lock Objects

This new feature allows you to lock Objects so that they will not move. This is great when you are showing people what you have been doing and are in edit mode.

As well as great for presentations when you do not want anything to move.

You can find more information here: Power BI Desktop Nov 2017 – Lock Objects

Conclusion

If there are any items that are not included in my Infographic or are incorrect please let me know in the comments section below.

BI-RoundUp – Power BI (Nov 2017 Desktop Update – Single Sign-On for Gateway Data Sources)

It is the start of the second week, and that meant that there was an update for Power BI Desktop, as well as some of the other related Services. I do hope you enjoy this weeks updates.

Power BI – Nov 2017 Desktop Update

As you can see we now have the Power BI Desktop update for November 2017. And as I do every month, I will go through what I feel are the highlights up the recent update.

Reporting

There is a lot to highlight in this section so below are some of the details.

  • All below relates to both table and matrix.
    • Cell Alignment, which as you can see above you can align them left, right, center and Auto
    • Rule based Conditional formatting, which you can also see in the image above.
  • Next there is the option to control the ordering of your images that you have in your selection pane, which is a great improvement.
  • Now you can also lock the objects in your report, so if you are doing a demo or showing someone the report, none of your objects will move.
  • ESRI Plus subscription available for ArcGIS. This allows you to use your ESRI subscription within the Power BI Service, with regards to more geocodes, additional base maps, living Atlas reference layers enabling you to add more context. As well as world demographics with the Infographics features.
  • Query Reduction has now been implemented for Live Connections or DirectQuery.
    • What this will do is for example when you are using slicers it will wait until you have made your entire selection, and once you click Apply will it then send one query. In the past it used to send one query every time you clicked on a slicer.
  • Filtering has also been improved so that there is no longer a 500 value limit.
  • There have been 4 new Custom Visuals added.
    • Image Timeline – This allows you to display events along a timeline with images. And then you can interact with them.
    • Social Network Graph – Which will show visual connections between people.
    • Venn Diagram – to find commonality between different categories
    • HTML Viewer – Lets you display HTML text strings, which enables your text to look a lot better

Analytics

There is now support for Cell-Level formatting for Multi-Dimensional Analysis Services to Multi-Row Cards this month.

Data Connectivity

There is now support for Windows Authentication for the Impala connector

Query Editing

There have been even more updates for the Columns from Examples.

The additional items below are:

  • Basic Conditional Column – Define a mapping between values in an input column and the desired output
  • Conditional column ranges – Define a new column with non-uniform ranges (I am thinking that they mean different length requirements)
  • Null fallback – This is where you could have multiple columns and you want to extract the values that are NOT null
  • Bucketing (Uniform Ranges) – Define an upper/lower boundaries for a range for a certain row and it will try and copy the uniform ranges

You can find all the details as well as the video here: Power BI Desktop November Feature Summary

Power BI – Single Sign-On for Gateway Data Sources

There is now single Sign-On for selected data sources that use DirectQuery via the On-Premise Data Gateway.

Currently the supported data sources are:

  • SQL Server
  • Teradata
  • SAP HANA

And there will be future support for:

  • Oracle
  • Impala
  • SAP BW
  • Spark
  • More to follow

You can find all the details here: Announcing Single Sign-On Support when connecting to data sources from the Power BI Service

Overview of what is coming to Power BI in the next few months!

With all the recent updates and announcements from SQL Pass, as well as the Power BI World Tour.

And there is a lot of great things to look forward to coming in the next few months!

Please understand that some of the pictures I have got from Twitter or elsewhere, so whilst they are not the greatest image quality, but rather showing what is coming. I am really excited to start using the new capabilities once they become available.

What is coming to Power BI Desktop

  • It is great to see that there will be enhanced enterprise readiness in terms of higher data points, which has been seen with the scatter plots.
  • As well as additional report sharing functionality.

  • There is also going to be a whole host of new connectivity to Adobe Analytics, Hive.
  • It is also great to see that there is Azure Active Directory Authentication coming to Azure SQL DB, Azure SQL Data Warehouse.
  • As well as even more enhancements with Columns from Examples

  • Next in the Visuals & reports, FINALLY to have slicers working across multiple pages.
  • Drill filters to other visuals in the report will also get filtered based on what you drilled down to.
  • Theming improvements, which I know a lot of people are starting to use.
  • And finally adding in more conditional formatting rules.
    • And here is an example below of what it might look like.
    • Thing to note is the rules are applied top to bottom.
    • So if you wanted to have a specific colour for a single value, then put it at the bottom and you will get it because it gets evaluated last.
    • There is also the ability coming to add column description information, which is great for end users to easily understand what the column is being used for.

  • And finally, Q&A is coming to Power BI Desktop, which means that you can use it on your report pages in Power BI Desktop and leverage Q&A. It is an easy way to create some visuals for your data.
    • You can easily double click and ask a question to your data.
    • Apparently you can use Q&A for TimeLine type of questions such as This Week, or This Month, etc and the charts should automatically move over time.
  • One thing that really interests me is the Query Reduction options, and how that can improve the query performance or loading of data, this is for Live Connection or DirectQuery sources.

Additional Power BI Updates for the Roadmap

Unfortunately, I did not have the time to make it all look pretty and together, so here is another list of roadmap items that are coming in the next few months.

Power BI Desktop

  • There will be additional Quick Insights added. Interested to see what will happen here!
  • Cross highlighting across multiple visuals which I am looking forward to, so that I can now select multiple items and see what story the data is telling me. Or find some amazing new insights within my data.
  • Updates to Bookmarks, which will give you more control over what is being booked marked for each individual bookmark.
    • This could potentially apply to the data, page etc.
    • This could also potentially decide which visual will be affected by a particular bookmark.
    • There is a long time plan to get Bookmarking to all the different flavours of Power BI, being the Web Service, Publish to Web and Power BI Embedded.

Power BI Service

  • The ability to Share datasets, I am not sure how this will work, but once again it will be interesting to see how this will work, and potentially will be great for larger customers.
  • I think that the Clustered capacity might be for the On-Premise Data Gateway, which I talk about below.
  • And finally, the capability to export to PDF, which I know is going to be a very welcome addition for people who want to have a hard copy of a Power BI report.

Power BI Report Server

  • The ability to bring in multiple data sources and refresh them is now available.
  • Adding additional items to the REST API.
  • And having additional SharePoint Integration, which in larger organizations is great, because it means that they can leverage their existing SharePoint investments.

App Updates

  • This is something that I personally know some organizations have been struggling with is the Office 365 groups when creating App Workspaces, and finally this is going to be removed.
  • Pushing the app to the users is great, because sometimes you want to give it to the users, so that they do not have to go and search for their data or are unaware of the analytics available to them.
  • Being able to selectively publish content from App Workspace is something people have been asking for a long time, and one of the main reasons people have not moved from Organizational content packs.
  • Being able to copy between content packs, which will enable the development lifecycle to work more seamlessly from Dev, to Test to Prod.
  • And finally, another big one is the ability to be able to share your Apps externally with external clients. And if you leverage this with Row Level Security you can now let your customers view their data.

On-Premise Data Gateway Updates

Once again there are a whole host of updates coming for the On-Premise Data Gateway

  • There is now Single Sign On (SSO) for Direct Query for SQL Server Database, Teradata & SAP HANA
  • They are looking to enable SSO to Oracle, Impala & SAP BW before the end of 2017
  • OAuth support for data mashup scenarios, which means using the Query Editor to import data from multiple sources into one dataset without any Mashup (or Applied Steps)
    • And coming soon will be including using the Query Editor to import data from multiple sources with steps being applied to the data.
  • Once again, another great feature that enterprise organizations as well as smaller organizations is the ability to have High Availability and basic load balancing.
    • This will now mean that you can have the data refreshing always available.
    • And I am interested to see how the Basic Load Balancing will work, which will be awesome when multiple datasets are refreshing at once.
  • And finally, is the use of Custom Connectors within the On-Premise gateway, so that once you have created your own custom connector it now can be refreshed via the Gateway.

Power BI – Client Advisory Team

Coming soon to Power BI is a Client Advisory Team (CAT), which Adam Saxton is going to be a part of. This will be great for strategic Power BI Customers on how to ensure that they are able to leverage Power BI.

BI-RoundUp – Power BI (Power BI Report Server GA Update – Announcements from SQL Pass – Help improve Power BI – How Data will Influence the future of Story Telling)

Here is my weekly BI RoundUp, it is a day late but I thought there might be more announcements from SQL Pass, so decided to delay it by one day. So here are this week’s updates.

Power BI – Power BI Report Server GA Update

With SQL Pass, there has been an announcement that you can now download and either update or install the Generally Available Power BI Report Server. There are some amazing new capabilities highlighted below.

  • Scheduled Refresh supported for data sources.
    • You can also schedule the refresh as often as you like.
    • As well as have multiple refresh schedules.
  • The size of the PBIX has been increased to 2GB
  • Additional support for DirectQuery for the following sources:
    • SQL Server Analysis Services
    • SQL Server
      – Azure SQL Database
      -Oracle
    • Teradata
    • SAP HANA
    • SAP BW
  • If you have a Shared Dataset in Reporting Services, you can now connect to this using the OData source in Power BI.
  • URL Report Filtering is now also available, which is very similar to the Power BI Service Implementation
  • Updates to the REST APIs for Power BI Report Server which can access folders, reports, KPIs, data sources, datasets, refresh plans, subscriptions, and more

You can find the download location and blog post here: New version of Power BI Report Server now available

Power BI – Announcements from SQL Pass


From the SQL Pass there are some updates coming to the Gateway. As you can see above there will now be the capability for Single Sign-On for Row Level Security which is great.

As well as high availability for the Gateways, I know that this is something larger enterprises, as well as organizations have been looking for to ensure that their data is always up to date. From the people that I follow on twitter this should be available very soon (Possibly Mid-Nov 2017)

As you can see above the capability to share specific items from an App Workspace is coming to Power BI.

Amazing, coming soon to Power BI will be the capability to share to an external email address or B2B (Business to Business). This will really be good when wanting to leverage your existing Power BI reports to external customers.

Power BI – Help Improve Power BI

There is a quick Survey where I was asked some questions with regards to Power BI. It is one page long, so it does not take a lot of time.

Along with this there is the opportunity to win 3 $50 gift cards, if you wish to leave your name and email address.

Here are the details here: Help Improve Power BI Desktop

Power BI – How Data will influence the Future of Story Telling

This is a great article in which they go on to explain how in the future a lot of storytelling will be backed by data. And how Microsoft Power BI is enabling people now to tell their story in an easy and meaningful way.

You can read all about it here: How Data will Influence the Future of Storytelling

Power BI – How to do Pagination in Power BI Reports

In this blog post I am going to demonstrate how to achieve Pagination in Power BI reports, using the new Bookmarking feature. I got this question from a follower on Twitter Murali Krishna

With the new bookmarking feature there now is a way to make it appear that you can page through Power BI reports.

Below is what it looks like in action.


Parameters

I used the following Parameter as shown below, which I then used later to automatically determine how many rows to show per page

How I got the Page Numbers based on the Rows Per Page Parameter

In this next section, what I did was to use my parameter with my data so that I could determine the page numbers dynamically.

By using the parameter this enabled the data to always get the right number of rows for each page dynamically.

  • This is what my data looked like at the start.
  • The first thing that I did was to add an Index by going into the Add Column ribbon and clicking on Index Column and then From 1
    • NOTE: The reason that I started at 1, was because when I am showing the rows it starts from 1
  • I then duplicated the Index Column, so that I could then use this to create the page number.
  • Next, I clicked on my column called “Index – Copyhighlighted below in Yellow
  • Then in the Transform ribbon I clicked on Standard and then Integer-Divide
  • I then manually put in a value of 10
  • Next, I wanted to change it from a static value to use my parameter value, so I did it by doing the following.
    • This is what it looked like with the Static value in the M Code
      Table.TransformColumns(#"Duplicated Column", {{"Index - Copy", each Number.IntegerDivide(_, 10), Int64.Type}})
    • I then changed it from 10, to my Parameter value, as shown below highlighted in PURPLE
      Table.TransformColumns(#"Duplicated Column", {{"Index - Copy", each Number.IntegerDivide(_, #"Rows Per Page"), Int64.Type}})
      • NOTE: The Parameter name is case sensitive.
  • The final steps was I added 1 to my column, so that once again the page number started from 1. And then I renamed it to reflect the page name
  • This is what it looked like once complete.
  • I now loaded this into my data model.

Creating the Pagination

I am not going to go into every step due to it will make this blog post too long, but I will demonstrate how I got the Pagination working.

  • The first thing that I did was to show the Bookmarks Pane.
  • Next what I did was to show my data based on the page number.
    • What this did is it enabled my data to be dynamic
      because it was based on the parameter, if I had to change how many rows to show to 25, due to the way I modelled the data in the Query Editor it would then have 25 rows per page.
  • I then created 4 bookmarks as shown below, with each being linked to a page number in the filter section.
  • I then also created measures to display the page that I am on.

    Pagination = “Page ” & SELECTEDVALUE(‘Sheet1′[Page Number],1) & ” of ” & [Max Page Number]

  • As well as the Records Measure

    Record Rows = ” Records ” & [Start Index] & ” to ” & [Max Index] & ” of ” & [Max Index Records]

  • Now the final piece, which does take some time to get right, was to enable the buttons to go forwards and backwards. So that when the user clicks on the buttons it appears that they are going forwards or backwards on each page.
    • I had to enable the Selection Pane Window
    • I had created an image for a Forward button and a Backwards Button
    • I then inserted my Forward Image.
    • NOTE: Always make sure that you are on the Bookmark Name where you want the interaction to take place.
      • I then clicked on the Forward Image and went to the Properties.
      • I then set the properties for the Link to type Bookmark and to Page 2 as shown below.
      • Then I went to the Bookmark called Page 1 and clicked on Update
      • I then went to the Bookmark called Page 2
        • I then went to the existing image and clicked on Hide
        • I then imported my Forward Image again.
        • I then clicked on the Forward Image and went to the Properties.
        • I then set the properties for the Link to type Bookmark and to Page 3 as shown below.
        • I then imported my Backward Image.
        • I then clicked on the Backward Image and went to the Properties.
        • I then set the properties for the Link type to Bookmark to Page 1 as shown below.
      • I then had to repeat this for all the other pages, as well as hiding the images on the different pages.
      • As well as ensure that the images were in the identical place as per the other images. This made it appear as it was the same button.
  • I then finally uploaded this to the Power BI Service and tested it to ensure that it worked as expected.

Conclusion

As you can see I demonstrated how to do Pagination in Power BI, it is a bit complex to get it right. But what I really like is that when it is done right, it appears seamless to the end user and VERY easy to use. Which is always my goal to make the end result as simple as possible.

Below is the report in action, if you want to click through and test it.

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 common questions that are asked when evaluating the Power BI licensing options.

You can read more about it here: Power BI Pro & Power BI premium: Flexibility to choose the licensing best for you and your Organisation

Power BI – On-premise Data Gateway Update for October

In this month’s update includes the updated version of the Mashup Engine (Query Editor Engine).

As well as some new beta connectors (Vertica)

You can find more details here: On-Premise data gateway October update is now available

Power BI – Developer Community Update

In this blog post, there are details around new functionality and changes for the Power BI Developer.

There are some great details around Power BI Embedded, where they explain the difference scenarios on how to leverage Power BI Embedded.

I know that this can get confusing as there is Power BI Embedded with an “A” SKU, an “EM” SKU and “P” SKU. They go through this really well so that it is easy to understand which SKU to use in which scenario    .

There is now also new functionality to embed Q&A. This is great if you want to provide the Q&A functionality within your app. The interactive mode is where you use it as you would in the Power BI Service, whilst in the Results only mode where the user will only see the result of the Q&A question.

There is now added support to set new filters dynamically for the Relative Date Slicer, the Include or Exclude as well as the TopN filters.

Finally, there is an update to the Custom Visuals API which is now on version 1.8

You can find more details here: Power BI Developer community October Update

Power BI – Duplicate Workspaces using the REST APIs

This update relates to how you can duplicate as well as move content around to new App Workspaces using the Power BI APIs

They even provide a sample PowerShell script, where all that you need to do is to put in your ClientID which you get when you register an app and you are good to go.

There are some limitations currently, but what this does allow you to do, is to be able to copy content to different App Workspaces, as well as be able to change the source connections. So this can work if you have a Dev App Workspace and a Prod App Workspace, and you can transfer the content across changing the source connection from Dev to Prod.

You can find more details on how to use the APIs here: Duplicate workspaces using the Power BI REST APIs: a step-by-step tutorial

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 every 7 rows
  • What I wanted is that for every 7 rows the Index number to be the same.

(more…)

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 you can find it from the Microsoft Power BI Blog post here: Power BI Bookmarking

In my blog post today, I am going to demonstrate how to create bookmarks, and then create a home page and link the images through to specific bookmarks, which will enable a seamless navigation experience for report consumers.

I am going to be using my Strava data, and I will create bookmarks for my bike rides, runs and
swims that I have done in the past. I will then create a new Home page and link images to those specific bookmarks.

Ensuring you have got all the Bookmarking features enabled

The first thing that I did was to ensure that I had the bookmarking preview feature enabled. Then also to ensure that I could see the bookmarks pane

  • I went into the Power BI Desktop, clicked on Options and Settings and then on Options
  • I then ensured that I had a tick box next to bookmarks under the Preview Features section
    • I then clicked Ok
  • The final step was to click on View in the Ribbon and ensure that I had put a tick box for bookmarks Pane

Creating the Bookmarks

Now I will be demonstrating is how to create the bookmarks.

  • To create my bookmark, the first thing that I must do is to be on the page where I want to create the bookmark.
  • Next, if there are any slicers or filters then I made sure that I had that completed also.
    • As with my example the first bookmark that I am going to create is for Riding.
    • In my Page Filters I put in the Activity Type and selected Ride.
    • Now when I look at my report it is only showing my bike rides.
    • Then in the BOOKMARKS pane I clicked on Add
      • As you can see above it defaulted to the name of Bookmark 1
        • I then double clicked and renamed it to Bike Riding
        • NOTE: You can also click on the ellipses and select Rename
      • Once I completed my first bookmark it had the correct name.
  • I then added in the following two bookmarks.
    • Running
    • Swimming
    • NOTE: If you are looking to replicate this, I did this by simply following the steps above, but where I selected Ride I changed it to be Run and then Swim
  • Once I had completed my Bookmarks for my Activity Types I had the following bookmarks completed.

Creating my Home Page and linking it to a specific Bookmark

What I did next was to then create a home page with some images and link it to a specific bookmark.

  • I created the home page and put in 3 images, one for each activity as shown below.
  • Next to link a particular image to a bookmark I did the following.
    • I first clicked on the Swimming Image
    • Then in the FORMAT IMAGE pane, I set the Link to On
    • Where it said Type I clicked on the Drop Down and selected Bookmark
    • Then below where it said Bookmark I clicked on the Drop down and selected Swimming (From the bookmark I had created earlier)
    • So once complete for my Swimming Image it had the following link properties
    • I then did this for my Bike Image
    • And then finally I did it for my Run Image

Creating my Home Page Navigation

The final step was for me to create my Home Page navigation so when I clicked on the Home Image it would take me back to my Home Page from within my report.

  • To do this I made sure I still had my BOOKMARKS pane open, and that I was on my Home page.
    • I then clicked on Add under BOOKMARKS
  • I then renamed it to Home Page
  • I then also put the Home Page bookmark at the top of the bookmarks.
    • NOTE: The reason for this is so that when you start your Bookmarks in the Power BI Service it will start at the Home Page.
  • I went into my report page and inserted a Home Image
  • I then clicked on the Image, and went to the Link Properties.
    • I then made sure that it was linked back to the Home Page Bookmark

I then uploaded my Power BI Report to the Power BI Service.

Testing my Bookmarking

Once I had uploaded it to the Power BI Service, I wanted to test it to ensure that it is working as expected.

  • To do this I went to my report and by default I could click on the Swim, Bike or Run and it would link me correctly to the correct bookmark.
  • Likewise, I could click on the Home Icon and it would take me back to the Home Page
  • Below is what it looks like in action.
    • I am clicking through to the Bike Activities, and showing I can still interact with the report.
    • I then go back to the Home page and click through to my Running Activities.
      • Once again interacting with the data in the report.
    • And then finally going back to the Home Page

Conclusion

As I have demonstrated not only is the new Bookmarking feature great for storytelling, but it is also a feature that can be leveraged to create a seamless report navigation experience.

As always if there are any comments of questions, please leave them in the section below.

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 update in this month’s release is the availability of Bookmarks. This is a fantastic feature and now enables you to really capture that story telling with your data. It is really easy and simple to configure.

What is also a great feature is that once you have your bookmarked steps, you can still interact with the data in each step. So for instance if someone is asking details about a particular bookmark you can stop and click on items in your visuals to answer the questions.

Next is the selection pane as shown above. What this allows you to do is to either show or hide each element on your report page.

This is great both for if you want to individually get to the properties of an item on a complex page with a lot of visuals.

As well as if you want to create an impression that visuals are dynamically changing you can do this with the combination of the bookmarks.

Another feature related to Bookmarks is the ability to link an image or shape to a Bookmark.

What this then means is that you can give the feeling of navigating from a visual to a page with the filter in place. The example that the Power BI Team shows in their video is having a selection of countries. You click on a country flag and that takes you to the report showing the report with the flag that you click on. Which is actually a bookmark.

Along with the bookmarks feature is the ability to spotlight a specific chart of visual as part of your bookmarking process. This is handy when you want to give specific focus to an item on the report.

There have been some additional improvements to the Scatter charts, where now where you can change the shape type for the different scatters.

As well as they have improved how many items you can see from 3000 to 10 000.

Analytics

In the Analytics area for Power BI they have now created the functionality to be able to create Quick Measures with SSAS Live Conenctions. This is great for when there is a requirement to quickly create another measure that does not exist on an SSAS live connection.

There is also a new quick measure called “Sales from New Customers”, which allows you to see your sales from New Customers.

There is now also the capability for when you have created Cell-Level formatting in your SSAS instance. This will now be honoured when you bring the data into your Power BI Model.

Data Connectivity

There is a new connector for Vertica, which if you use it you can now leverage it inside of Power BI.

There has also been updates for the SAP BW Connector with additional member properties.

And finally, there has been improved Help access from within Power BI Desktop. There is now additional items on the Help Ribbon in Power BI Desktop.

You can find the video as well as all the other details here: Power BI Desktop October Feature Summary

Power BI – Email Subscriptions for Apps


As you can see above on the left-hand side is the option to subscribe to a Dashboard in my App. And on the right-hand side is the option to subscribe to the report in my App.

This now allows your users who have access to Apps, to now be able to get the information in their Inbox daily.

You can read about it here: Introducing email subscriptions for Power BI apps

Power BI – Monthly Service & Mobile Update

There was a whole host of updates to the Power BI Service in the past month, some of which I was unaware of until reading the blog post. So please find all the relevant details below.

You can now share Dashboards with Free Power BI Users if your App Workspace is on a Premium Capacity. This is great, because before this update you could only share Apps with Free Users.

With Power BI Premium, there now is the option to change how you want to allocate your V-Cores. If you have a larger Premium capacity you can then modify the settings so that you could allocate it to a smaller SKU.

Leading on from the above is you now can very quickly in one click scale up or scale down your Capacity. Once again this is based on the number of V-Cores that you have purchased.

Now there is also the capability to use PubNub Blocks to push data into the Power BI Rest API

There was also an update to the Power BI On-Premise Gateway with an updated version for Personal mode which is in line with the Enterprise mode. The support for Government clouds in Personal mode. As well as the Gateway now has the September update for the MashUp Engine.

You can now also filter reports in the Power BI Mobile App, which is something that is often needed because you only want to see the data you are interested in.

There is now support for Visio across all the platforms for Power BI including the Web as well as mobile platforms.

And finally, there was an update rolled out for improved performance for the Usage Metrics, which in the past did take a while to load, but now is a LOT quicker.

You can read up about it all here: Power BI Service and Mobile September Feature Summary

Power BI – AI Recommendations for Apps

Now when you search for Apps within your Organization it will use the AI engine to suggest what other Apps might be of interest to you.

Not only will this allow you to be able to potentially have insights to data that you did not know were there. But it also honours the Security that is put in place for access to Apps. If you do not have access to the App, then you will not see the recommendation.

You can find all the details here: Announcing AI-powered app recommendations: getting the right insights to the right people

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 also included the UTC Offset, which I did blog about previously Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times which will ensure when the Power BI Desktop file is uploaded and refreshed within the Power BI Service it displays the correct Date and Times.

(more…)