Logo
banner

Blogs

Attach files to Notes record of Microsoft Dynamics 365 CRM/CE from the D365 CRM Custom Portal

, September 30, 2019517 Views

From the D365 CRM portal, it is now very easy to attach files to the Notes record of an entity. In the Additional Settings area of the Entity form, there is a section named “Add Attach File”. You just need to select the checkbox for “Attach File”. Doing this will add a File Control on […]

Read more

Power BI > How to fetch Dynamics 365 CE data

, September 20, 2019387 Views

Power BI provides several different ways to fetch data from Dynamics 365 CE and today I will share my know-how on them. 1. Dynamics 365 Online Connector This method is mostly used to fetch data from Dynamics 365 CE. Initially, this was the only method to fetch data from CE. To use this, go to Get […]

Read more

Filter subgrid based on the lookup field value in Microsoft Dynamics 365 CE

, September 10, 2019843 Views

Let’s learn today how to filter the sub-grid on a form based on the lookup field value. Below is an example where we will create a sub-grid of a custom entity named “Agents” on the Contact entity form which will display records based on the “Account Name” lookup field value on the Contact form. For […]

Read more

Power BI > Dynamic Scales & Values

, August 31, 2019784 Views

Hello DAX-sters! We have already created a report where we can choose what data we can show – dynamically. You can refer to the blog here. How about we get the freedom to choose even how the data can be shown, i.e. weekly, monthly, quarterly, or yearly? Every so often we need the availability of […]

Read more

Power BI > Size limits to consider while choosing the right capacity

, August 9, 2019284 Views

Many of us often face difficulties understanding the dataset size limits in different scenarios and different capacities. So, here is a quick understanding of the same. Different type of capacities: 1. Shared Capacity 2. Premium Capacity 3. Azure Power BI Embedded Capacity Power BI provides either Shared Capacity or Premium Capacity. Power BI, by default, […]

Read more

Power BI > Sharepoint Online List as Data Source

, July 19, 2019301 Views

Power BI has been growing day by day with the new features that the Power BI team is bringing every month. One of the great features for those who are working with Sharepoint Online is that we can use “Sharepoint Online” List as a data source in Power BI to get an overview about Sharepoint […]

Read more

Error Handling in Microsoft Flow

, July 11, 2019444 Views

The Microsoft Flow provides us no-code solutions which help us to achieve the requirements faster. But, what if we want to manage the things based on the errors or breaks in the flow and if the flow is failed due to some reason? In this blog, I will explain to you how to handle errors or […]

Read more

Automatically schedule the SSRS Report and send it as PDF attachment with the email in Microsoft D365 CE/CRM

, June 21, 20191228 Views

The Microsoft D365 CE/CRM provides the feature to run the selected SSRS reports manually. But I had the requirement to schedule the execution of report on a user-specified frequency like daily, weekly or monthly and send the report to the user via email as an attachment. But I did not find any OOB feature in […]

Read more

SSRS – How to handle multi tenants in single instance?

, June 11, 2019256 Views

Problem Statement: We have different SQL databases for different tenants(or clients), and we want the same SSRS report to fetch data from different databases based on the user who is executing the report. To achieve this, we can have a data source that is dynamic by using an expression-based connection string. Below is a quick explanation […]

Read more

Sort the PowerApps data using the GPS Location

, June 10, 2019448 Views

Let’s learn today to sort the data of PowerApps based on the current GPS location. In the below example, we are having Microsoft Dynamics CRM 365 as the database of the PowerApp. This PowerApp was basically developed for one of our client requiring a mobile application that will be used by their Customer care department […]

Read more