{Quick Tip}Steps to convert UTC Date time fields to local format in POWER BI for CRM online

June 15, 2016 deepeshsomani2013 Microsoft Dynamics CRM

Recently in CRM online project, our customer started reporting that Date fields are off by a day on some random data rows.

The reason to that is the time zone is not considered automatically.

Here is a step by step resolution:

https://community.dynamics.com/crm/b/scaleablesolutionsblog/archive/2016/03/25/convert-utc-date-format-into-local-time-format-in-power-bi

Hope it helps and Happy CRMing!

If you want to know more on Dynamics CRM, just get in touch.

Do not forget to share! Sharing knowledge is true power!

Twitter: https://twitter.com/msdynamicsblog
LinkedIn: https://www.linkedin.com/in/deepesh-somani-00296932

Google Play Store:

https://play.google.com/store/apps/details?id=com.dynamicsofdynamicscrm.msdynamicsblog&hl=en

{CRM 2016 Update 1} Overview and Step by Step for Relevance search in Dynamics CRM

June 10, 2016June 10, 2016 deepeshsomani2013 Microsoft Dynamics CRM

Relevance search is a new feature that came up with CRM 2016 Update 1. In case of Relevance search basically uses concept of scoring – so more the score more relevant is a search term.

Underneath Relevance search utilizes same concepts as Azure Search.

So, here is a quick overview:

Since it’s a preview feature you will need to enable it in Settings->Administration->System settings->Preview.

Once you select yes and enable it, we need to navigate to Customizations:

Select the entities you want and click ok.

Now, field level, you can configure fields to include under Quick find columns:

Above is sample for Account entity.

Next thing when I try to search for Datum under Search box:

Nothing is found, but we also have an option for Use Relevance search:

It finds it using power of Azure! Great feature.

How does it work? Here is the architecture referred from Technet:

There are some limitations and considerations. Detailed Read:

https://technet.microsoft.com/en-us/library/mt723654.aspx

Hope it helps and Happy CRMing!

If you want to know more on Dynamics CRM, just get in touch.

Do not forget to share! Sharing knowledge is true power!

Twitter: https://twitter.com/msdynamicsblog
LinkedIn: https://www.linkedin.com/in/deepesh-somani-00296932

Google Play Store:

https://play.google.com/store/apps/details?id=com.dynamicsofdynamicscrm.msdynamicsblog&hl=en

{Survey results} Scenarios for which Plugins are used in Dynamics CRM

June 8, 2016June 9, 2016 deepeshsomani2013 Microsoft Dynamics CRM

Thank you all for submitting your valuable feedback. Here are the results.

There were total of 67 votes submitted and here is where we CRM people use plugins for:

Other scenarios included:

A late entry in others is SMS integration.

Hope it helps, Happy CRMing!

Do not forget to share!

Twitter: https://twitter.com/msdynamicsblog
LinkedIn: https://www.linkedin.com/in/deepesh-somani-00296932

Google Play Store:

https://play.google.com/store/apps/details?id=com.dynamicsofdynamicscrm.msdynamicsblog&hl=en

{POWER BI} Unleashing POWER BI to do Map based analytics

June 7, 2016June 7, 2016 deepeshsomani2013 Microsoft Dynamics CRM

Do you have data stored in CSV/Excel files and wished you could do some map based analytics with it. Well POWER BI lets you do all of that?

Here I have collected a random data of my Blog traffic across regions and am uploading this into POWER BI desktop:

Launching POWER BI desktop:

Once Loaded:

Now I can do some insights on this data:

On visualizations I took Filled map, Chose Country as Latitude and Hits as Longitude:

Here is the result:

Not only did it plot all content, it has relevant tooltips for each region with color encoding:

Pretty cool, isn’t it?

Well, just wait. The next thing I am going to show is I am going to get Hits added to the filter, For this I am just dragging the field for Hits to Page Level filters area: