Dynamic page navigation in Power BI based as per User Role
Inkey, March 1, 20241675 Views
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 […]
Read moreHow to get direct count using Fetch XML capabilities
Inkey, February 27, 20243627 Views
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 […]
Read moreUnlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API
Inkey, February 23, 2024663 Views
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 […]
Read moreIntegration of Business Central APIs and Web Services with OAuth
Inkey, February 20, 2024992 Views
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 […]
Read moreIs Microsoft Dynamics 365 Business Central the best ERP?
Inkey, February 19, 2024687 Views
ERPs or Enterprise Resource Planning applications have been around for a very long time now. They started off as simple table heavy software applications leveraging computers’ ability to store data indefinitely and retrieve data at any time with speed and accuracy. Over time as databases evolved into relational databases, computers became faster and could store […]
Read moreAchieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround
Inkey, February 16, 20241356 Views
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 […]
Read moreAdd custom fonts in SSRS Report
Inkey, February 13, 20242965 Views
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 […]
Read moreParse JSON for Multi-Type Properties
Inkey, February 6, 20241929 Views
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 […]
Read moreCreate apps from Figma in Power Apps
Inkey, January 30, 20241161 Views
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 […]
Read moreStreamlining Business Operations with Microsoft Dynamics 365 Business Central, Microsoft Power BI Consulting, and Power Apps Services
Inkey, January 24, 2024914 Views
In today’s dynamic business landscape, organizations are constantly seeking innovative solutions to enhance their operational efficiency and gain a competitive edge. One such transformative suite of services offered by Inkey IT Solutions Pvt. Ltd. includes Microsoft Dynamics 365 Business Central, coupled with Microsoft Power BI Consulting and Microsoft Power Apps Services. Let’s delve into the power-packed […]
Read more
