Dependent Assemblies Update!
Inkey, November 7, 2022303 Views
Hey Readers, breaking news!! and good ones this time!! Microsoft has released supported way for dependent assemblies in plug-ins. This release was released for public review for admins, makers, marketers, analysts automatically on 31 July 2022. General availability is yet to be announced. Currently developers use ILMerge Utility to combine set of assemblies in plug-in, […]Read more
Power BI > Accessibility of reports published in same app workspace
Inkey, November 4, 202293 Views
Usually, Power BI Reports are shared with users by giving them access to the App Workspace where we have reports published. So, when we have 2 groups of users – let’s say, Manager and Salesperson. And there are 2 sets of reports, Set1 & Set2, where Set1 is to be shown only to Salesperson, and […]Read more
Copying environment variables from one environment to another using SQL query
Inkey, October 7, 2022159 Views
As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development phase or the underground lab) -> UAT (for testing phase or Racoon city) -> PROD (for real-time application or the world). In SSIS also, we are able to deploy the same SSIS package in 3 different environments, but […]Read more
Dynamics 365 Sales Solutions: Are You Doing It Right?
Admin, October 7, 2022279 Views
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 choice. Simple? Wait. Hear the options and you will realize just how sadistic I actually am. Give yourself some time to think and you will sympathize with me. You […]Read more
SQL Server > Find a specific value in all the tables of a database using T-SQL
Inkey, September 2, 20221450 Views
Often times we find ourselves in a situation where we want to find a particular value but we are unaware of its whereabouts, i.e., we don’t know in which table or column this value is present. Or we want to know in which other tables a particular value is present. Or just if this value […]Read more
Introducing Power Pages!
Inkey, August 20, 2022509 Views
Microsoft Power Pages is a part of the Microsoft Power Platform family. It is an evolution of Power Apps portals. The new features included are the new design studio. The templates are in preview for users to try and provide feedback. We can expect general availability of the Power Pages by next year. We can […]Read more
How to quickly match data of two recordsets in SQL Server?
Inkey, August 10, 2022280 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
Inkey, July 8, 2022345 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
Inkey, June 27, 2022718 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
Inkey, June 24, 20221267 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