Logo
banner

Blogs

Power BI > How to filter all the data by TODAY, by default?

, September 10, 2021252 Views

Ever wondered how we can filter the Power BI report to show only Today’s data by default but at the same time give the flexibility to change the Date filter? The approach we as developers generally take is – create a calculated column IsToday in the Calendar table and have it return “Yes” for today’s […]

Read more

Load metadata of all entities and get Object Type Code based on Entity name in Dynamics 365 for Sales.

, August 12, 2021220 Views

In this blog I’ll be taking you over how to get the Object type Code for the particular entity based on the Entity name. Suppose we need to get object type code for different entities in a loop in an stand alone .Net application. Generally, people are writing a fetch into the loop but not […]

Read more

Updating the SQL DataSource from Power BI using Power Automate Visual

, August 6, 2021279 Views

Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was […]

Read more

Latest Updates in Business Central V 18.3

, August 5, 2021185 Views

Description This blog will describe the updates on Business Central 18.3. Below is the list of the major updates available in Dynamics 365 Business Central. Document Objective G/L Entry Dimension Correction. Inventory Documents. Item Availability by Lot No. Variant codes on production orders in Business Central. In this blog we are going to discuss some […]

Read more

Schema Update Mode in AL code for Dynamics 365 Business Central

, July 23, 2021441 Views

Description:  This blog will describe the significance of the Schema Update Mode and why it is used in Business Central. We were facing some issues while working on the table extensions and realized that we could not change the data type or the size of the custom fields we described in the extension once published. […]

Read more

Calculation Groups in Tabular Editor

, June 11, 2021638 Views

Consider a scenario where your measure’s definitions are the same but the only difference is the base measures. For example, while doing time-related calculations like MTD, YTD, QTD for 3 different calculations/measures, we need to create 3 measures for MTD, 3 measures for YTD, and 3 measures for QTD, resulting in total 9 measures such […]

Read more

Create and Configure model-driven app interactive experience dashboards

, June 10, 20212226 Views

In this blog I will show you how to create and configure Interactive experience dashboards in model driven apps. The Interactive dashboards are fully configurable and security-role based and deliver information across multiple streams in real time. The Interactive dashboards have two forms: multi-stream and single-stream. Multi-Stream dashboards can be table-specific dashboards. The multi-stream dashboards […]

Read more

Setting up the Custom Columns of SharePoint with Power Automate Flow and displaying them in Documents Grid in Dynamics 365 for Sales

, June 2, 2021616 Views

Many times while uploading the documents of Dynamics CRM to the SharePoint we require that the fields of Dynamics CRM be reflected in the SharePoint column and we could also see the value populated in SharePoint Column in CRM. If you have any such requirements, stay tuned, as this blog is going to cover all […]

Read more

Power BI > Embed Dashboard/Report in D365 Sales with RLS – 5

, April 30, 20211279 Views

There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own drawbacks and cons that might not complement your requirements. Earlier we have posted blogs that describe the 4 approaches but as I said they have their own pre-requisite and cons. With the advancements of Power BI […]

Read more

Secure Authentication of SharePoint with PnP Framework with C#(Code)

, April 30, 20211739 Views

For a while, we had been using a NuGet Package named SharePointPnPCoreOnline(as shown in below image), which can be used for authentication to SharePoint and other SharePoint Client Side Object Model (CSOM) tasks for managing SharePoint Online Data. This is what we used in our previous blog posts part1 and part2 to connect using clientid/client […]

Read more