• Power BI Desktop Memory Issue Resolution - Part 2

      Colin Maitland, 08 February 2019

      In part one of this article, I described my experience of a “not enough memory to complete this operation” error I encountered in Power BI desktop. In this part, I will describe the cause and resolution for this issue. The cause of the issue was actually the formula used for generating the Sequentia

      Read the full article here
    • How to Connect Power BI to Dynamics 365

      Satyvir Jasra, 07 November 2018

      Power BI is a power analytics tool that allows us to visualize our data. We can create reports in Power BI using Dynamics 365 data. In this blog I will walk through the steps to create a connection between a Dynamics 365 instance and make a simple report using it. I will be using Power BI desktop a

      Read the full article here
    • Unable to View Shared Power BI Dashboard in Dynamics 365

      Satyvir Jasra, 13 September 2018

      We can create and share Power BI dashboards with other users, and similarly we can create a personal dashboard in Dynamics 365 and share it with the other users. Occasionally users like to create and share personal dashboards with other users. However, some users might report an issue where they do

      Read the full article here
    • How to Use Power BI Dashboards in Dynamics 365

      Satyvir Jasra, 11 September 2018

      With the Power BI and Dynamics 365 integration, many Power BI reports and dashboards are created using Dynamics 365 data. However, there are times when we don’t want to maintain charts in Dynamics 365 and Power BI separately. Therefore, it is best to use Power BI dashboard itself in Dynamics 365. In

      Read the full article here
    • Introduction to Power Query with Power BI

      Jordan Hohepa, 16 June 2017

      This blog is the second in a series of blogs focused on Microsoft’s analytics service, Power BI. In the previous blog I focused on importing data into the Power BI desktop version, while in this blog I will be focusing on Power Query. The data I imported as an example was from the “Rotten Tomatoes T

      Read the full article here
    • Importing Data to Power BI

      Jordan Hohepa, 24 May 2017

      Recently I was fortunate enough to participate in a workshop focused on Microsoft’s analytics service, Power BI. This blog will be the first in a series of blogs describing my experiences with Power BI. In this blog, I will focus on importing data into the Power BI desktop version. The remainder of

      Read the full article here
    • Microsoft Dynamics 365 Business Application Platform in a nutshell

      Arpit Malhotra, 25 January 2017

      Microsoft’s business application platform let organizations innovate business solutions faster. It helps them to build and extend modern business applications by composing analytics, user experiences, tasks automation all together using a wide-ranging and integrated set of services. It offers a rich

      Read the full article here
    • Anomaly/Outlier Detection using Excel and SQL Server Analysis Services

      Ahmed Anwar, 16 December 2015

      In this article, I’m going to talk about how to use the SQL Server Data Mining Excel Add-in to detect odd patterns in records or datasets. Anomaly detection (or outlier detection) is the process of identifying unexpected patterns in a dataset. Typically anomalous problems appear in Banks, errors in

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 3

      Colin Maitland, 19 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the second layer of a Power Map report in Microsoft Excel to display Account Reven

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 2

      Colin Maitland, 17 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the first layer of a Power Map report in Microsoft Excel to display Account Number

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 1

      Colin Maitland, 17 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data retrieved from a Microsoft Dynamics CRM Online Organisation using a Power Query query. In this blog I will demonstrate how to create a Power Map report and configure the first layer to

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 3

      Colin Maitland, 14 July 2015

      This is the third blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The report is based on an ODataFeed related query created using Power Que

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 2

      Colin Maitland, 13 July 2015

      This is the second blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The completed report will look similar that shown below. In my prev

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 1

      Colin Maitland, 11 June 2015

      In this blog and the next two blogs I will demonstrate how to create a simple Power View report in Microsoft Excel that displays information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. This report uses a Power Query named AccountOpportunitiesSet previou

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 3

      Colin Maitland, 03 June 2015

      In my previous blog I demonstrated how to convert a Column Chart that displays the Sum of Estimated Value by Account into a Pie Chart. In this blog I will demonstrate how to update the Column Chart to display both the Sum of Estimated Value and the Sum of Actual Value. I will also demonstrate how to

      Read the full article here