.Net
Dependent Assemblies Update!
Hey Readers, breaking news!! and good ones this time!! Microsoft has released supported way for dependent assemblies ...
Read Article
.Net
MS BI
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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