Author: Carl de Souza

Power BI · Apr 14, 2017

Power BI Direct Query Limitation

To use direct query mode, select your supported data source and then DirectQuery: Click OK and you will then be able to…

Read article →

Power BI · Apr 14, 2017

Getting Data Excel 2016

Excel 2016 has built in BI capabilities. To get data from an external data source, go to the Data tab: Under Get and…

Read article →

Dynamics 365 Customer Engagement (CRM) · Apr 12, 2017

Dynamics 365 Solution Templates Install – Sales Management

To install the Sales Management for Dynamics 365 Solution Template, go through the following steps. Go to https://powerbi.microsoft.com/en-us/solution-templates/dynamics-crm/ Click Install Now: Select the…

Read article →

Azure · Apr 10, 2017

Azure Service Bus Sample

Azure Service Bus is an enterprise cloud messaging service for offline and online applications and services. Let’s go through an example of…

Read article →

Dynamics 365 Customer Engagement (CRM) · Apr 10, 2017

Dynamics 365 PowerShell – Microsoft.Xrm.Data.Powershell

The Microsoft.Xrm.Data.Powershell module for PowerShell provides data operations such as CRUD. The module is available for download at: https://github.com/seanmcne/Microsoft.Xrm.Data.PowerShell/releases/ Download the ZIP file and…

Read article →

Power BI · Apr 8, 2017

Power BI and Local Excel Data Refresh

Here we will cover the scenario where there is a local spreadsheet file on a user’s desktop, and we have a Power BI desktop…

Read article →

C# · Apr 7, 2017

Write to Text File in C#

First, create a new console app: Next, add: using System.IO; Now add code: using (StreamWriter writer = new StreamWriter("filename.txt")) { writer.Write("1"); writer.WriteLine("2");…

Read article →