In Power BI, providing page security and role-based access to users traditionally involves creating different workspaces or different audiences in one app workspace. However, an innovative approach is to achieve this using measures, eliminating the need for additional workspaces and audiences. In this blog post, we will explore a real-time requirement where we need to… Continue reading Dynamic page navigation in Power BI based as per User Role
FetchXML in Dynamics 365 is a query language used to retrieve data from the system. It is a powerful and flexible tool that allows users to define complex queries to retrieve specific data from Dynamics 365 entities. An aggregate function into FetchXML queries, we can enhance data retrieval capabilities in Dynamics 365. Whether we can… Continue reading How to get direct count using Fetch XML capabilities
Say hello to Databricks, a dynamic platform merging the power of Apache Spark with collaborative workspaces allowing flexibility to use multiple programming languages (Python, Scala, SQL) within a single environment. This versatility surpasses the constraints of predefined transformations in pipelines, allowing for more intricate and customized data transformations. Data Pipeline Hiccups: The ‘Content-Type’ Snag Let’s… Continue reading Unlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to connect Business Central APIs and Web Service with OAuth. Microsoft Dynamics 365 Business Central, offers a set of powerful APIs and… Continue reading Integration of Business Central APIs and Web Services with OAuth
Greetings, BI enthusiasts! When working with Power BI reports and handling numerical data with multiple hierarchies, the Matrix visual is often the go-to choice. It seamlessly accommodates hierarchical data with proper modeling, allowing the use of measures as rows. However, what if you need to display measures as rows with specified indentations, sorting, and font… Continue reading Achieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround
Adding custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can… Continue reading Add custom fonts in SSRS Report
JSON (JavaScript Object Notation) is a widely used data format for storing and exchanging data. It is easy to read, write, and parse, making it a popular choice for data interchange. However, when working with JSON data, you may encounter scenarios where a column or field can contain multiple types of data. In this blog… Continue reading Parse JSON for Multi-Type Properties
The ability to create PowerApps from Figma design files directly helps bridge the gap between design and development by accelerating the app UI development process. It allows developers and designers to collaborate effectively and efficiently to deliver great end user experiences with low cost and effort. Designers can create designs in Figma using the Create… Continue reading Create apps from Figma in Power Apps
In our previous blog, we delved into the inner workings of Deployment Pipelines. Now, we shift our focus towards a crucial aspect of Power BI development – integrating Git with workspaces in Power BI Service, especially those that play a pivotal role in your Deployment Pipelines. Integrating Git with Power BI Workspaces Our journey now… Continue reading Part 3: Git Integration for Content Management
In our previous blog post, we delved into Power BI Projects and Git integration, catering to the needs of developers with Pro Capacity. Today, we venture further into the fascinating world of Power BI Deployment Pipelines. Our focus is on providing you with insights into how to seamlessly handle content within your development lifecycle. Unveiling… Continue reading Part 2: Streamlining Power BI Deployment Pipelines
In a much-anticipated move, Microsoft has unveiled Git Integration in Power BI for developers who work with Power BI Desktop Projects. This ground-breaking feature which is in preview, promises to revolutionize the way developers streamline development, source control, and collaboration within their Power BI projects. In this technical blog, we’ll delve into the intricacies of… Continue reading Part 1: Git Integration with Power BI
The email deduplication in Customer Insights feature prevents sending of duplicate emails to the same email address, ensuring a more efficient communication process. Email deduplication is enabled in journeys through the setting of customer insight journey but is disabled by default and applies to all segment-based journeys. How to enable email deduplication Open Customer Insights… Continue reading Email Deduplication In Customer Insights
In the dynamic landscape of database management, maintaining and evolving database schemas is a critical aspect. Visual Studio provides a powerful platform for managing these tasks efficiently. In this blog post, we’ll explore the ins and outs of using SQL Schema Compare for altering, creating, and deleting objects, and discuss why Visual Studio is a… Continue reading Leveraging SQL Schema Compare in Visual Studio for Efficient Database Management
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your process is to identify posted purchase receipts and invoices against order. Prerequisites: Verify that the organization has valid licenses for Microsoft Dynamics 365 Business Central. Required Business… Continue reading Identify Posted Purchase Receipt and Invoices Against Purchase Order
The Power Page backup process is a very simple process using PowerShell. The command is a single line that combines three to four commands mentioned in the Microsoft documentation. This one-liner helps you export and saves you time. As per the Microsoft documentation, we can take by using a 3–4-line command. By preferring this blog,… Continue reading Power Pages Backup Using One Line PowerShell Script
To understand concurrency control in loop of Power Automate Flow/Logic Apps, let us try to understand in this blog about, what is concurrency in a loop, how it is beneficial of us and when we do not need to manage concurrency. What is Concurrency? Concurrency means one kind of parallelism where the number of operations… Continue reading Concurrency Control In Loop In Power Automate And Logic Apps
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your sales process is the ability to auto-create items in Business Central when entering item descriptions on sales lines. Requirement: How can we create item while entering item… Continue reading Auto create Item In Business Central While Entering Item Description In Sales Line
An email, phone conversation, task creation, or record update in the Dynamics 365 Sales system are examples of preset stages that make up a sequence. These actions can be initiated manually by the user or automatically in response to predetermined criteria. They are set up to happen in a particular order. These can be referred… Continue reading Sequence in Dynamics 365 Sales process
If you want to know how to create a progress indicator in Business Central using AL Code, look no further. This blog will teach you how. A progress indicator is a useful feature that lets the user know how much of a long-running process has been completed and how much is left. A progress indicator… Continue reading How to Create Progress Indicator in Business Central using AL Code
In this blog we are going to learn how to implement Dynamic Mapping to copy data from multiple sources to sinks in ADF. The below attached images show that there are 2 pair of source-destination tables. Now the source table is holding some data while the destination tables is blank, but its schema is similar… Continue reading Copy Data Dynamically From Multiple Sources To Multiple Sinks In ADF
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
