Our Latest Perspectives

PowerApps

May 5, 2022 2 min read

New Alternative of Navigate() function on App.StartScreen and App.OnStart in Canvas apps

We were facing some issue when writing code of Navigation in App.StartScreen and App.OnStart of App within PowerApps....

Read Article

Business Central

April 14, 2022 3 min read

How to insert new balances for Vendors and Customers in a new company in Business Central

Requirement: We had a requirement to import the balances of the Customers and Vendors in a fresh instance.  Issues: ...

Read Article

Power BI

April 8, 2022 4 min read

Embed Power BI reports in Power Apps Portal

We can now embed Power BI Dashboard/Reports in PowerApps Portal with few easy steps. Prerequisite:-    D365 Custome...

Read Article

Power BI

April 1, 2022 4 min read

Power BI > How to deal with a Text column having a length of more than 32766 characters.

Power BI supports up to 32766 characters of data in a column of TEXT Data Type. What if we have more data stored in t...

Read Article

Business Central

March 24, 2022 8 min read

Business Central latest updates 2022 release Wave 1

Here are some interesting new updates in the latest release for Business Central Blocking deletion of G/L accounts Th...

Read Article

Azure

March 11, 2022 3 min read

Access SharePoint Online Data Using Postman Part 2

Now, in this blog we will see how to access SharePoint online data.  In this example, we will resize SharePoint Onli...

Read Article

Dynamics 365 for Sales

February 23, 2022 3 min read

Set Default Font style and Size of Email in Dynamics 365 Sales

In this blog we will see how we can set default font style and font size for the Email records in Dynamics 365 Sales....

Read Article

Azure

February 3, 2022 4 min read

Access SharePoint Online Data Using Postman Part 1

In this blog, we will show you how we can interact with SharePoint via Rest APIs and perform actions like adding, upd...

Read Article

Power BI

December 20, 2021 3 min read

Power BI > Using slicer for just highlighting values without filtering

The general purpose of slicer visual in Power BI is to filter the data points in the report and view only the ...

Read Article

Power BI

November 19, 2021 4 min read

Power BI > Drill-through feature from Card visual 

In Power BI, a drill–through feature permits the report consumer to peer detailed facts associated with th...

Read Article

Dynamics 365 for Sales

October 28, 2021 5 min read

Dynamics 365 Sales data import. Anomalous materials and unforeseen consequences

We all have imported data into CRM at some point in our life. And a part of the process of importing data is cleaning...

Read Article

Power BI

September 10, 2021 4 min read

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

Ever wondered how we can filter the Power BI report to show only Today’s data by default but at the same time give ...

Read Article

Dynamics 365 for Sales

August 12, 2021 3 min read

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

In this blog I’ll be taking you over how to get the Object type Code for the particular entity based on the Entity ...

Read Article

Power BI

August 6, 2021 5 min read

Updating the SQL DataSource from Power BI using Power Automate Visual

Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers ...

Read Article

Business Central

August 5, 2021 3 min read

Latest Updates in Business Central V 18.3

Description This blog will describe the updates on Business Central 18.3. Below is the list of the major updates avai...

Read Article

Business Central

July 23, 2021 3 min read

Schema Update Mode in AL code for Dynamics 365 Business Central

Description:  This blog will describe the significance of the Schema Update Mode and why it is used in Business Cent...

Read Article

Power BI

June 11, 2021 5 min read

Calculation Groups in Tabular Editor

Consider a scenario where your measure’s definitions are the same but the only difference is the base measures. For...

Read Article

Microsoft Dynamics 365

June 10, 2021 4 min read

Create and Configure model-driven app interactive experience dashboards

In this blog I will show you how to create and configure Interactive experience dashboards in model driven apps. The ...

Read Article

Dynamics 365 for Sales

June 2, 2021 4 min read

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

Many times while uploading the documents of Dynamics CRM to the SharePoint we require that the fields of Dynamics CRM...

Read Article

Business Intelligence

April 30, 2021 4 min read

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

There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own d...

Read Article

Dynamics 365 for Sales

April 30, 2021 3 min read

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

For a while, we had been using a NuGet Package named SharePointPnPCoreOnline(as shown in below image), which can be u...

Read Article

Dynamics 365 for Sales

April 16, 2021 2 min read

How to preserve Modified By and Modified On fields during Migration in Dynamics 365 for Sales

In this blog I’ll be taking you over how to preserve “Modified On” and “Modified By” fields during migratio...

Read Article

Logic Apps

April 1, 2021 4 min read

Setup Authentication of Logic Apps using Logic Apps settings

This time we will see how to authenticate logic apps. What is Logic Apps? Azure Logic Apps is a cloud service that ...

Read Article

Power BI

March 12, 2021 4 min read

Power BI > Get Data from OneDrive for Business (Folder as a source)

Microsoft Power BI supports many data sources from where we can fetch data and a good Microsoft Power BI Consulting s...

Read Article

PowerApps

March 5, 2021 5 min read

Do we need Dynamics 365 any more?

Microsoft introduced Power Apps a while ago. These can be considered a very small version of Dynamics 365. These apps...

Read Article

.Net

February 25, 2021 7 min read

Attaching media files from SharePoint to Dataverse Email records

I was wondering if we had any tools, workflow solutions, automatic processes or any connectors in PowerAutomate to su...

Read Article

Business Central

February 17, 2021 2 min read

How to set-up Jet Reports in Business Central – Part 2

In the previous blog we learnt how to make a connection between Business Central and Jet reports. Jet Reports are fas...

Read Article

Business Central

February 10, 2021 3 min read

How to set-up Jet Reports in Business Central – Part 1

Overview on Jet Reports: Jet Reports are fast and flexible financial reporting solution that helps to eliminate the e...

Read Article

Power BI

February 5, 2021 3 min read

Power BI > How to easily copy Measures from one pbix file to another?

Have you ever questioned if it is feasible to move all of the measures from one Power BI PBIX file to any other PBIX ...

Read Article

.Net

February 4, 2021 8 min read

Append Content Dynamically in Document Template and Generate the Merged Document in Dynamics 365 for Sales and SharePoint

We all have been using Document Templates which are directly available by system and these templates contains static ...

Read Article

Business Central

January 29, 2021 3 min read

Working with the Analysis view in Business Central

What is Analysis view? There are 2 global dimensions which help to analyze the data in the whole Business Central sys...

Read Article

Power BI

January 21, 2021 3 min read

Power BI > USERELATIONSHIP Vs. CROSSFILTER

Power BI has different DAX functions using which we can have our results in many different ways. As far as the result...

Read Article

Microsoft Dynamics 365 v9.0

January 21, 2021 4 min read

Creating Appointment of Dynamics 365 for Sales with Plugin which would reflect in Outlook Calendar as a reminder.

There are some requirements at times when we need to book Appointment in Dynamics 365 for Sales on creation of Lead w...

Read Article

Dynamics 365 for Sales

January 12, 2021 5 min read

Connection to Dynamics 365 and SharePoint Authentication Using ClientId & ClientSecret: Part 2

In our previous post, we saw what needs to be done in Azure and Dynamics 365. Now we will see the code part. Before w...

Read Article

Dynamics 365 for Sales

January 8, 2021 3 min read

Connection to Dynamics 365 and SharePoint Authentication Using ClientId & ClientSecret: Part 1

I have come across various requirements from clients where it was more feasible to go with creating the C# console ap...

Read Article

.Net

December 4, 2020 9 min read

Import data into Dataverse(CDS): Part 3

In the previous blogs, we saw how to import data into Dataverse(CDS) using Excel here and Dataflow here. In this blog...

Read Article

Power BI

November 26, 2020 4 min read

Power BI > How to make PBI Reports pointing to deleted Power BI Dataset working again?

Recently, we had come across an issue which we thought is very common and is easily resolvable. But, we were highly m...

Read Article

CDS

October 16, 2020 4 min read

Import data into Dataverse(CDS): Part 2

In our previous blog, we saw how to import data into a Dataverse(CDS) environment using Get data from Excel option. I...

Read Article

CDS

September 25, 2020 4 min read

Import data into Dataverse(CDS): Part 1

There are multiple ways of importing data into a Dataverse(CDS) environment. And by Dataverse(CDS) , I mean just the ...

Read Article

Power BI

September 18, 2020 4 min read

Power BI > How to handle multiple time zones?

We have often encountered requirements that need the date and time columns to change according to the timezones of th...

Read Article