Software + Imagination
In Power BI, we have the ability to analyze report data in Excel. There are several ways to access this functionality. For example, select a data source and then Analyze in Excel: Alternatively, select Reports and then Analyze in Excel: Or, go to Apps and select your app: Select View Related: Select the Analyze in Excel icon: Once you select Analyze in Excel, you will see “First, you need some … Continue reading Power BI – Analyze in Excel
Quick Insights are a feature of Power BI that analyses data sets and finds patterns, trends and outliers. Once your data is uploaded to the Power BI cloud, you can use the Quick Insights feature. Using it is simple. First log into https://powerbi.com. Go to a report you have created in your app workspace and select the Quick Insights icon: Alternatively, select the Dataset and View Insights. The insights actually … Continue reading Using Quick Insights in Power BI
To create a report in the Power BI Service, go through the following steps. Log into https://powerbi.com and select your app workspace: Click on Dataset and select a dataset. If you do not have one, create one. For example, to create a dataset from an Excel file, select + Create ->Dataset: Under Files, select Get: Select Local File. I have a customers.csv file I will upload: The dataset will be … Continue reading Creating a Report in the Power BI Service
Power BI can connect to Dynamics 365, so we can build reports connecting the two systems. In this post, we will go through building your first Power BI report connecting to Dynamics 365. The steps we will go through to build a report are: Connect Power BI Desktop to the Dynamics 365 Web API Remove Columns and Add Columns through Power Query (M) Create Relationships and Build the Report Publish … Continue reading Building Your First Power BI Report for Dynamics 365
To delete a Git branch from Visual Studio, go to Branches: Ensure the branch you want to delete is not currently opened as your working branch, i.e. not bold: Right-click it and select Delete: The branch is now deleted:
To clone a repository from GitHub in Visual Studio 2019 Start Menu, and select Clone a Repository: Enter a path and click Clone: The repository is created: In local path:
When running a plugin, developers may see the error: The data contract type ‘Microsoft.Xrm.Sdk.OrganizationServiceFault’ cannot be serialized in partial trust because the property ‘ExceptionRetriable’ does not have a public getter. One reason for this, is when you are using tracing in your plugin, you should have tracing enabled in Dynamics 365 settings. Code: [sourcecode language=”CSharp”] ITracingService tracingService = (ITracingService)serviceProvider.GetService(typeof(ITracingService)); tracingService.Trace("Tracing"); [/sourcecode] In System Settings, enable:
To install the Word Cloud Visual by Microsoft for Power BI, first open Power BI Desktop, and under Visualizations, select Import from marketplace: Find Word Cloud and click Add: Click OK: Now under Visualizations you will see the Word Cloud icon: Select it. In our example, our Opportunity records have a name field, which describes customer opportunities. We will use that as the Category of the word cloud. You can … Continue reading Installing and Using the Word Cloud Visualization for Power BI
To create a dashboard in the Power BI service, go through the following steps. First, select your workspace: From the top right, select Create->Dashboard: Provide a dashboard name, e.g. Carl’s Dashboard: You will see a blank screen with options. Select + Add Tile: You can select from: Web Content Image Text box Video Real-Time Data Web Content Select web content. Click Next: Here we can add web content such as … Continue reading Creating a Dashboard from Within Power BI Service
To change the theme in Azure Portal, log into the portal at https://portal.azure.com and select the Settings icon in the top right: Here you will see the options to choose a theme, and the high contrast theme settings: Selecting a theme will change it right away: