Power BI Archives | Page 17 of 17 | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure - Page 17

Category Archives: Power BI

Customized Error Handling in TIBCO Scribe Insight

Posted On August 17, 2015 by Posted in Tagged in ,

Consider migrating the data from Microsoft dynamics CRM online to Microsoft dynamics GP. Our goal is after the data migration is completed successfully, we want the result of the data migration (successful/failure) to go back to the source system. Steps: Scenario: 1st block: We query the source account entity 2nd block: We try to update/insert … Continue reading Customized Error Handling in TIBCO Scribe Insight

Share Story :

On-Premise Data Refresh in Power BI

Posted On August 13, 2015 by Posted in

Purpose of this blog is to refresh on-premise data sources available in Power BI. Prerequisite: Microsoft SQL Server Management Studio, Microsoft Excel 2013, Power BI Desktop Tool, Microsoft Data Management Gateway Steps for On-Premise Data in Power BI: Setting up On-Premise Data Refresh in Power BI will help refresh data directly from the data source … Continue reading On-Premise Data Refresh in Power BI

Share Story :

Filtering Activity Party using Scribe Insight

Posted On July 9, 2015 by Posted in

Note:  This article assumes experience on Scribe Insight for Data Integration/Migration and understanding of CRM Online Activities like Email, Letter, phone Call etc. have Attributes of type Party List that have to be set up using Activity Party entity as the source and destination. Steps for filtering Activity Party: Select Primary data object as Activity … Continue reading Filtering Activity Party using Scribe Insight

Share Story :

Powerful DAX CALCULATE() Function

Posted On June 24, 2015 by Admin Posted in Tagged in ,

The CALCULATE function in DAX is the magic key for many calculations we can do in PowerPivot. Below is the syntax: CALCULATE( <expression>, <filter1>, <filter2>… ) The expression that we put in the first parameter has to be evaluated to return the result (i.e. a value, not a table). For this reason, the expression is … Continue reading Powerful DAX CALCULATE() Function

Share Story :

Resolving Time Zone Issue in PowerPivot

Posted On June 10, 2015 by Posted in

Key Technologies: Power BI, PowerPivot, Business Intelligence Note: This article assumes experience on PowerPivot for Excel 2013/2010 Many a time data needs to be imported and processed from systems belonging to different locations and hence having different time zone. For example, consider the following scenario. A user residing in India having IST time zone might … Continue reading Resolving Time Zone Issue in PowerPivot

Share Story :

Attachment and Task migration through Scribe Insight

Posted On June 5, 2015 by Posted in

Key Technologies: Scribe Insight, CRM Online Note: This article assumes experience on Scribe Insight for Data Integration/Migration and understanding of CRM Online Sources: CRM, Salesforce TASK Activities like Tasks need to be migrated and linked to an entity (Account, Contact, Lead, Opportunity and so on). For storing the GUID from CRM, perform a seek step … Continue reading Attachment and Task migration through Scribe Insight

Share Story :

Activity Party Migration using Scribe Insight

Posted On June 1, 2015 by Posted in

Key Technologies: Scribe Insight, CRM Online Note: This article assumes experience on Scribe Insight for Data Integration/Migration and understanding of CRM Online For all the Activities like Email, Letter ,Fax ,Phone Call etc. we need two packages to be set up a: Activity Entity to Activity Entity (Eg: Email to Email) [with Status= Open] b: … Continue reading Activity Party Migration using Scribe Insight

Share Story :

What’s New in Power BI?

Posted On May 28, 2015 by Posted in

Key Technologies: Microsoft Business Intelligence, Power BI Note: This article assumes experience on Power BI for Office 365 using Excel 2013 and the Microsoft BI stack Power BI transforms data into rich visualizations independent of Office 365 and SharePoint Online. Newly available features: Powerful Dashboards using HTML5 without the need to install Silverlight New Visualizations … Continue reading What’s New in Power BI?

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close