Power BI Dynamics 365 Content Packs Source Code

There are 3 Dynamics 365 content packs for Power BI that Microsoft has provided the PBIX files for download. These files are opened with Power BI Desktop and can be modified and then uploaded to your Power BI environment. To download the PBIX file source code, go to: https://technet.microsoft.com/en-us/library/mt490470.aspx: Select the links to download: From here you will have the source, which you can then customize:  

Dynamics 365 Cases

To create a new case, or issue, in Dynamics 365, go to the Services menu and select Cases: Here, you will see the case, the origin, case number, priority etc: Select a case to open it: Note the Business Process Flow for the case: You may want to create child cases if your case relies on separate departments to complete the main issue. To create a child case, select “Create … Continue reading Dynamics 365 Cases

Dynamics 365 Bulk Delete Jobs

Dynamics 365 has the ability to schedule data for deletion. To do this, go to Settings->Data Management: Select Bulk Record Deletion: Click New and the Bulk Deletion Wizard will appear: Select the entity whose records you want to delete. Enter any additional criteria: If you do not enter any additional criteria you will get this message: Click Next: Note you can schedule when to repeat the job: Click Next and Submit … Continue reading Dynamics 365 Bulk Delete Jobs

Upgrading Unified Service Desk

To upgrade Unified Service Desk, go through the following steps. First, download the latest Unified Service Desk from the Microsoft link: https://www.microsoft.com/en-us/download/details.aspx?id=50355 Check the files and download: Open the executable (non-Package Deployer). Click Next: Keep the options checked and click Install: You will then get this message: Clicking Settings->About and also the login window will show the new version: In Dynamics 365, we see the following solutions and versions for USD: … Continue reading Upgrading Unified Service Desk

Install Power BI Dynamics 365 for Sales Content Pack

To install a Dynamics 365 Content Pack for Power BI, go through the following steps. First, log into powerbi.com. Then, select the Get Data at the bottom of the screen: This will open the page below: Select under Services Get. Search for Dynamics: Select the Microsoft Dynamics 365 Online Sales Manager. Click Get It Now: Enter your Dynamics 365 URL and Fiscal Year End Month Number. Note the trailing / … Continue reading Install Power BI Dynamics 365 for Sales Content Pack

Power BI Service and Importing and Uploading Excel Spreadsheets

Here we will look at how using Excel spreadsheets as datasources works with Power BI. Let’s start with a spreadsheet we have stored locally on our server. The file is called ExcelTransactions.xlsx and is stored locally. It contains rows of data (that have been typed into the spreadsheet and are not external data sources): In PowerBI.com, select Get Data->Files->Get: Select Local File: Select our ExcelTransactions.xlsx file. We will now see this page: Select … Continue reading Power BI Service and Importing and Uploading Excel Spreadsheets

Power BI Groups, Sharing and Editing Reports

Let’s say you create a report and dashboard, and you want to share that with other users in your organization. You may or may not want users to edit the report or dashboard. Let’s look at the different ways this is achieved. Here I have a simple report that displays accounts by state. I have published this under an admin user: To share with users, I can click on the dashboard … Continue reading Power BI Groups, Sharing and Editing Reports

Dynamics 365 Entities – Enabling and Disabling Features

When you create a new entity in Dynamics 365, there are some restrictions as to what you can disable if they were first enabled. Here we will take a look at these options. When you first create a new entity, you will see the following available and pre-checked: You can see at the bottom of the screen, it says “After you enable this option it cannot be disabled”. This includes: … Continue reading Dynamics 365 Entities – Enabling and Disabling Features