Logo
banner

Blogs

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

, August 10, 202212 Views

While working with T-SQL, many times we create complex queries, and then we might need to optimize them at some later point of time to reduce the execution time. This activity always demands an approach to compare data for the older and newer version of the T-SQL. And here comes the question – how do […]

Read more

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

, July 8, 202255 Views

In the earlier blog post, we stated how to identify referenced measures or columns, i.e. whether they are used in other measures or not. If you haven’t visited the blog post, please click here. It is a very useful blog, especially in the big Power BI models. But this won’t be helpful when we would […]

Read more

Download Large SharePoint Files From PowerApps Portal

, June 27, 2022178 Views

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, stored in their SharePoint server. They wanted to allow their customers to be able to download these files from the company portal. The portal was the PowerApps Portal. But then, […]

Read more

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

, June 24, 2022395 Views

Most of the time, while updating the existing model, it’s hard to identify which measures or columns are being used in report visualization and which are referring to other measures or columns. Many times, while developing a report, there are frequent changes in the requirements and we need to modify/update the data model accordingly, which […]

Read more

Low code! No Code! Then why code?

, June 6, 2022270 Views

The no code/low code options are coming in, nice and easy. They don’t always make a big splash like the newest JavaScript framework. They don’t always give the open-source crowd nose bleeds that the newest JavaScript framework/newest language/newest stack/newest update of their favorite framework would do. The hard-core developers would scoff at these solutions especially […]

Read more

Migrate Audit records from Dynamics 365 CRM to Azure SQL Server

, May 12, 2022712 Views

Storage space comes at a premium in Dynamics 365 world. So, we need to manage it carefully and aggressively. When audit is enabled, the space it occupies creeps up steadily and silently and we only notice it when we get a message from Microsoft telling us we have run out of storage space. So, a […]

Read more

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

, May 5, 2022494 Views

We were facing some issue when writing code of Navigation in App.StartScreen and App.OnStart of App within PowerApps. It is widely used for the initialization of global variables, prefetching of data into collections, and to determine which screen should be shown first. By default, the first screen shown when an app starts is the first […]

Read more

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

, April 14, 2022550 Views

Requirement: We had a requirement to import the balances of the Customers and Vendors in a fresh instance.  Issues: The master data wasn’t imported in the system. No direct way to post the opening balances in the system. While posting the balances there was an error related to the General Journal posting. Solution: Master data […]

Read more

Embed Power BI reports in Power Apps Portal

, April 8, 2022692 Views

We can now embed Power BI Dashboard/Reports in PowerApps Portal with few easy steps. Prerequisite:-    D365 Customer Service organization having a Global user with D365 and Power BI license. ENABLE POWER BI VISUALIZATION  In the PowerApps select the environment where you have provisioned the Portal. Go to Your Apps section from Power Apps home page and locate […]

Read more

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

, April 1, 20221183 Views

Power BI supports up to 32766 characters of data in a column of TEXT Data Type. What if we have more data stored in the data source? Recently, we came across a requirement where we had to show the content of an email in HTML format in the Power BI report. The report was built […]

Read more