As you would possibly already know Microsoft introduced Energy BI 2.0 Common Availability, Energy BI 2.0 GA, on July 24. On this submit I clarify some new options which can be prepared to make use of now. Now I can say Energy BI is considerably improved throughout the preview interval. We’re capable of refresh on-prem datasets, we are able to modify the appear and feel of the experiences, we are able to share assets and far more now. As an illustration go to Energy BI web site and the very first thing you possibly can 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
Content material Pack Library
My Organisation: from right here you possibly can simply create you organisational content material packs. A content material pack is mainly a single repository to maintain dataests, experiences, dashboards, Q&A, integration with different knowledge sources, knowledge refresh and extra. You may as well package deal up and publish your dashboards, experiences and datasets along with your colleagues in a particular group or all the organisation. You may as well browse the content material packs that different folks in your organisation printed.
Providers: you should utilize a number of on-line providers constructed to hook up with completely different platforms like Microsoft Dynamics CRM, Microsoft Dynamics Advertising and marketing, Visible Studio On-line , and far more.
Import Or Hook up with Information
Recordsdata: You’ll be able to add your experiences, knowledge or workbooks from Excel, Energy BI Desktop or CSV recordsdata. The situation of the recordsdata may very well be your native laborious drive, on OneDrive Enterprise or OneDrive Private.
Databases: You’ll be able to connect with Azure SQL Database, Azure SQL Information Warehouse, SQL Server Evaluation Providers Tabular Mannequin or Azure HDInsight (Spark) and browse your stay knowledge.
Content material pack Library – My Organisation
As you possibly can 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 may have entry to this content material pack. In the event you select “My Complete Organisation” you then simply have to 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 is advisable to enter electronic mail addresses separated by semicolon (;) or comma (,)
Choose the gadgets you need to publish. If you choose a dashboard it would robotically choose all corresponding experiences and datasets.
You may as well add an organization emblem or picture by clicking on Add hyperlink
Click on Publish
Now you possibly can browse the content material pack you printed. Simply click on on “Get Information” once more after which click on on “My Organisation”. Now you possibly can see you new created content material pack.
You’ll be able to click on on it after which click on Join.
Whenever you connect with a content material pack you really are creating the dashboards, experiences and every thing on the content material pack once more. So once you publish a content material pack to a ogranisation or simply for particular group of individuals, they mainly will have the ability to create their very own model of the experiences and dashboards. Nonetheless, the dataset can 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 modifications to this report, it is advisable to convert it to new Energy BI report canvas”. You’ll be able to resolve to transform or cancel. Because the report that I opened is a check 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 precise pane that wasn’t obtainable 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 precise aspect of the web page you possibly can see some queries are highlighted in yellow. These queries are the queries which have some fields collaborating within the report. You’ll be able to broaden 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 possibly can see we are able to simply change the report kind by choosing one other report kind from the Visualisation pane. On this pattern I need 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 modifications on the legend. From legend choose “Left” and alter the legend textual content.
- In the event you don’t just like the chart’s color broaden “Information Colors”
- You may as well merely allow Information labels by clicking on “Information Labels”. You’ll be able to customise the information labels by altering color or precision
- You may as well change the chart’s title textual content and customise it as desired by increasing “Title”
- To vary the chart’s background color or transparency broaden “Background” and customise it
- As you observed you possibly can 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 might have 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. You may as well see the amount consumed by the datasets which can be shared with you by clicking on “Owned by Others”. In the event you don’t need a dataset anymore you possibly can delete it from right here.
Create Content material Pack
You’ll be able to create a brand new content material pack straight from right here. As I coated this half earlier I’m not going although it once more.
View Content material Pack
You’ll be able to view, edit or delete current content material packs.
As you see there’s a warning icon on the precise aspect of the content material pack. It’s as a result of I’ve made some modifications to the dashboard of the printed content material pack. If I hover over the warning icon I can see extra info.
This can be a actually superior function 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 function which is newly added. Now you possibly can simply change to your Energy BI for Workplace 365 account. There’s additionally a hyperlink for Energy BI which is newly added to Energy BI 365.
There are many different new options that can’t be coated on this submit. So I’ll focus on some extra options in my future posts.