As you would possibly already know Microsoft introduced Energy BI 2.0 Basic Availability, Energy BI 2.0 GA, on July 24. On this publish I clarify some new options which can be prepared to make use of now. Now I can say Energy BI is considerably improved through the preview interval. We’re capable of refresh on-prem datasets, we are able to modify the feel and appear of the experiences, we are able to share assets and far more now. As an example go to Energy BI web site and the very first thing you’ll be able to see is the Energy BI emblem is modified from Energy BI Preview to Energy BI.

Let’s see what’s new in Energy BI.

• Signal into Energy BI

• Click on on Get Information button from the underside of the left navigation pane

1. Content material Pack Library

   • My Organisation: from right here you’ll be able to simply create you organisational content material packs. A content material pack is principally a single repository to maintain dataests, experiences, dashboards, Q&A, integration with different knowledge sources, knowledge refresh and extra. It’s also possible to package deal up and publish your dashboards, experiences and datasets along with your colleagues in a selected group or your complete organisation. It’s also possible to browse the content material packs that different individuals in your organisation printed.

   • Companies: you should use a lot of on-line companies constructed to connect with totally different platforms like Microsoft Dynamics CRM, Microsoft Dynamics Advertising, Visible Studio On-line , and far more.

2. Import Or Hook up with Information

   • Information: You may add your experiences, knowledge or workbooks from Excel, Energy BI Desktop or CSV recordsdata. The situation of the recordsdata could possibly be your native arduous drive, on OneDrive Enterprise or OneDrive Private.

   • Databases: You may connect with Azure SQL Database, Azure SQL Information Warehouse, SQL Server Evaluation Companies Tabular Mannequin or Azure HDInsight (Spark) and browse your dwell knowledge.

Content material pack Library – My Organisation

• As you’ll be able to see there’s a transient definition of “My Organisation” which is “MY ORGANISATION IS WHERE YOU CAN FIND CONTENR PACKS PUBLISHED BY YOU AND OTHER IN YOUR ORGANISATION”

• Click on “Create Content material Pack”

• Select who could have entry to this content material pack. In case you select “My Total Organisation”  then you definitely simply must kind a title in addition to description for the content material pack then click on Publish. If you wish to publish the content material pack with particular teams then it’s essential to enter electronic mail addresses separated by semicolon (;) or comma (,)

• Choose the gadgets you wish to publish. If you choose a dashboard it is going to robotically choose all corresponding experiences and datasets.

• It’s also possible to add an organization emblem or picture by clicking on Add hyperlink

• Click on Publish

Now you’ll be able to browse the content material pack you printed. Simply click on on “Get Information” once more after which click on on “My Organisation”. Now you’ll be able to see you new created content material pack.

You may click on on it after which click on Join.

Once you connect with a content material pack you truly are creating the dashboards, experiences and all the pieces on the content material pack once more. So if you publish a content material pack to a ogranisation or simply for particular group of individuals, they principally will be capable of create their very own model of the experiences and dashboards. Nevertheless, the dataset will probably be a shared dataset which suggests they’ll simply discover it or delete it and nothing extra.

The report’s options are improved considerably. We are able to know change the chart’s colors, including free texts into TextBoxes and far more.

• After logging into Energy BI web site clock on a desired report
• Proper after you open the report you’ll get prompted to make use of the brand new report canvas

• After you open the report, click on on EDIT REPORT
• You would possibly get a message saying “To make adjustments to this report, it’s essential to convert it to new Energy BI report canvas”. You may determine to transform or cancel. Because the report that I opened is a take a look at report I’m protected to transform it.

• Now that your report is open click on on EDIT REPORT button

• You’ll instantly see a toolbox on the fitting pane that wasn’t accessible earlier than

• With the brand new options we’re capable of modify the visualisation as desired
• By clicking a chart associated options to the chart is added to the visualisation pane
• On this pattern I clicked on a bar chart

• Within the Fields pane on the fitting facet of the web page you’ll be able to see some queries are highlighted in yellow. These queries are the queries which have some fields collaborating within the report. You may increase them to seek out the fields. We are able to modify the report fields by dragging and dropping the fields into the reporting space OR into the “Fields” part of the Visualisation pane.
• As you’ll be able to see we are able to simply change the report kind by choosing one other report kind from the Visualisation pane. On this pattern I wish to change the report kind from Bar Chart to Donut Chart.

• To vary the Donut’s look and feel click on on “Format” from the Visualisation pane

• Let’s make some adjustments on the legend. From legend choose “Left” and alter the legend textual content.

• In case you don’t just like the chart’s color increase “Information Colors”

• It’s also possible to merely allow Information labels by clicking on “Information Labels”. You may customise the info labels by altering color or precision

• It’s also possible to change the chart’s title textual content and customise it as desired by increasing “Title”

• To vary the chart’s background color or transparency increase “Background” and customise it

• As you observed you’ll be able to at all times again to default by clicking on “Revert to Default”
• It can save you the report or put it aside as a brand new report

You’ve gotten extra management in your Energy BI now. Click on on “Settings” button.

Handle Private Storage

Click on on Handle Private Storage to see the way you consumed your storage. It’s also possible to see the quantity consumed by the datasets which can be shared with you by clicking on “Owned by Others”. In case you don’t desire a dataset anymore you’ll be able to delete it from right here.

Create Content material Pack

You may create a brand new content material pack immediately from right here. As I coated this half earlier I’m not going although it once more.

View Content material Pack

You may view, edit or delete present content material packs.

As you see there’s a warning icon on the fitting facet of the content material pack. It’s as a result of I’ve made some adjustments to the dashboard of the printed content material pack. If I hover over the warning icon I can see extra info.

It is a actually superior characteristic that I can replace the content material pack in order that the customers can at all times have the newest variations. To replace the content material pack simply merely click on on “Edit” then click on “Replace”.

Energy BI for Workplace 365

That is one other cool characteristic which is newly added. Now you’ll be able to simply swap to your Energy BI for Workplace 365 account. There may be additionally a hyperlink for Energy BI which is newly added to Energy BI 365.

There are many different new options that can not be coated on this publish. So I’ll talk about some extra options in my future posts.