axsa: Power BI and Dynamics AX: Part 3: Create and Publish Visualisations
This is Part Three, continuing from Part 2: Extract and Transform. This post will focus on the creation and publishing of visualisations.
At this point in the process we have a workbook, with a transformed data model – we are ready to create a visualisation to present our data. This post isn't meant to be a detailed guide of how to create a visualisation, you can find one here.
To get started with a PowerView Visualisation, from the workbook we built our query in we are going to click PowerView from the Insert tab.
Excel will load a blank PowerView sheet for you to begin creating your visualisation. Assuming your query was created you should now see your transformed data set in the "PowerView Fields" pane to the right of the screen. (If you don't – jump back here to see how to setup the query).
You can now start by checking the fields you would like to present in your visualisations, or dragging and dropping them from the field list onto the PowerView sheet. Once you start adding data you will notice a new ribbon "Design" is available, from here you can change visualisations and the presentation of the data.
Some key things to keep in mind when creating your PowerView visualisations:
Now you should have a workbook, including your data model and visualisation ready to share on PowerBI. The publishing process is quite simple, the main consideration at time of publishing is security.
Once you publish your workbook there Dynamics AX Security model is no longer applied – the data security is only applied at time of refresh. For example, if the designer of the report has access to 10 Dynamics AX Legal Entities, once they publish the report anyone with access to the workbook will see the contents. This is due to the fact that the information is uploaded into the Excel Data Model in Office 365 as part of the refresh process.
A key component of your PowerBI strategy needs to be focused on the plans for security related to your data. The security will be managed by SharePoint security, based on the workbook. As an example, if you create a folder in SharePoint for "Sales – West Region" and provide access to your West Region team, then only this team will have access to the report once its published to this folder.
The PowerQ&A service is also based on this security model, when a user asks a question on Q&A, PowerBI will look across all workbooks that user has access to within PowerBI. For this reason it's even more important to ensure the correct security has been setup from day 1.
Note: To publish your workbook in PowerBI for Office 365, you will need an Office 365 subscription and an active licence for PowerBI.
Firstly, you will need to create a PowerBI site on your Office 365 tenant if you haven't already done so, to create a new PowerBI site follow the detailed steps here.
Once you've created your new PowerBI site, you can upload your workbook by selecting "Add" > "Upload File" under the documents section.
Once the workbook is uploaded, you will notice it will automatically enabled itself for PowerBI. If you uploaded your document through the SharePoint library, or had already loaded it before adding PowerBI to your Office 365 tenant, you will need to enable the workbook manually. You can do this by clicking "Enable" on the ellipsis menu on the workbook.
One last step is to enable the workbook for PowerQ&A, this is also done from the ellipsis menu on the workbook itself. Workbooks will not be automatically enabled, the main reason here is you may have multiple workbooks with the same data source, you don't need to enable all of them for Q&A, only one as long as it's the same data source in the background.
Now that its enable you can click the workbook to see your visualisations on PowerBI. Done!
You'll notice in the bottom right hand corner you have an icon to take you to the HTML 5 view. It's recommended to always view your visualisations in HTML 5 to see how they are presented, depending on the device your user is using, you want to make sure the visualisations are clear and easy to understand. In some cases you will see it renders slightly differently in Excel vs HTML5 and may require some tweaking.
You've now got a Dynamics AX data source extracted and published in PowerBI. The next post in this series will talk about PowerQ&A and the data refresh options available for the data source.
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|axsa: Power BI and Dynamics AX: Part 1: Introduction||Blog bot||DAX Blogs||0||18.02.2015 18:11|
|dynamics-coe: Microsoft Dynamics AX 2012 Reporting Services – Integrated with SharePoint Farm||Blog bot||DAX Blogs||0||21.11.2014 13:11|
|atinkerersnotebook: Walkthrough & Tutorial Summary||Blog bot||DAX Blogs||1||09.09.2013 09:11|
|Опции темы||Поиск в этой теме|