Archive

Business Blogs

December 1, 2022 6 min read

Moonlighting is bad!

What is moonlighting? Moonlighting means having a job that is separate from and in addition to the regular job that a...

Read Article

.Net

November 7, 2022 3 min read

Dependent Assemblies Update!

Hey Readers, breaking news!! and good ones this time!! Microsoft has released supported way for dependent assemblies ...

Read Article

Power BI

November 4, 2022 3 min read

Power BI > Accessibility of reports published in same app workspace

Usually, Power BI Reports are shared with users by giving them access to the App Workspace where we have reports publ...

Read Article

MS BI

October 7, 2022 4 min read

Copying environment variables from one environment to another using SQL query

As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development...

Read Article

Dynamics 365 for Sales

October 7, 2022 5 min read

Dynamics 365 Sales Solutions: Are You Doing It Right?

Let me ask you a question. I give you two options and ask you to choose. I will ask you to give the reason for your c...

Read Article

MS SQL Server

September 2, 2022 4 min read

Microsoft SQL Server > Find a specific value in all the tables of a database using T-SQL

Often times we find ourselves in a situation where we want to find a particular value but we are unaware of its where...

Read Article

Microsoft Dynamics 365

August 20, 2022 6 min read

Introducing Power Pages!

Microsoft Power Pages is a part of the Microsoft Power Platform family. It is an evolution of Power Apps portals. The...

Read Article

MS SQL Server

August 10, 2022 4 min read

How to quickly match data of two recordsets in SQL Server?

While working with T-SQL, many times we create complex queries, and then we might need to optimize them at some later...

Read Article

Power BI

July 8, 2022 2 min read

Power BI > How to identify referenced Measures and Columns in Model – II

In the earlier blog post, we stated how to identify referenced measures or columns, i.e. whether they are used in oth...

Read Article

PowerApps Portal

June 27, 2022 4 min read

Download Large SharePoint Files From PowerApps Portal

A while ago, one of our clients gave us a vexing problem. They had a lot of rather large files, nearly 1 GB in size, ...

Read Article

Power BI

June 24, 2022 3 min read

Power BI > How to identify referenced Measures and Columns in Model – I

Most of the time, while updating the existing model, it’s hard to identify which measures or columns are being used...

Read Article

PowerApps

June 6, 2022 4 min read

Low code! No Code! Then why code?

The no code/low code options are coming in, nice and easy. They don’t always make a big splash like the newest Java...

Read Article

Dynamics 365 for Sales

May 12, 2022 3 min read

Migrate Audit records from Dynamics 365 CRM to Azure SQL Server

Storage space comes at a premium in Dynamics 365 world. So, we need to manage it carefully and aggressively. When aud...

Read Article

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