1. Introduction In today’s data-driven world, businesses rely heavily on automated data pipelines. While Fivetran provides many pre-built connectors, there are scenarios where your data source is simply not supported out-of-the-box. That’s where Fivetran Custom Connectors (Connector SDK) come into play. This guide is based on a real-world implementation: Keap API → BigQuery. In… Continue reading 🚀 End-to-End Guide: Building a Fivetran Custom Connector (Keap → BigQuery)
Turning End of Life Into a Smart Growth Opportunity This article is intended for finance leaders, IT managers, and Dynamics GP users planning their ERP roadmap. Microsoft Dynamics GP has been a dependable system for many organizations. It is stable, familiar, and deeply embedded in finance operations. That reliability is exactly why many businesses continue… Continue reading Dynamics GP to Business Central in 2026
Problem Statement A growing enterprise needed to streamline its email data management. Email activity data, stored in the organization’s CRM system, was essential for compliance, customer service tracking, and business intelligence. However, they faced major challenges: Email data was only accessible through complex CRM APIs returning paginated JSON. There was no centralized repository for email… Continue reading Email Data Migration from CRM to SQL Server using Azure Data Factory
Transitioning to the cloud is no longer optional for businesses—it’s a necessity to gain agility, scale, and cost savings. In the cloud, consistency and effective performance demands more than just a “lift and shift” of existing systems. Building cloud applications requires robust architectural principles. Here is the key to achieving this: Architect for Scale In… Continue reading Sound architectural principles required to ensure effective performance in the cloud
Introduction In the era of big data, transforming raw data into meaningful insights is crucial. Databricks, built on Apache Spark, provides a unified platform to perform ETL (Extract, Transform, Load) at scale. In this blog, we’ll explore what ETL is, how it works in Databricks, and walk through a hands-on practical example using a sample… Continue reading ETL in Databricks
Data is the force of any company and without solutions in business intelligence offered by Microsoft, a business firm runs the risk of getting relegated in its respective industry. It means with exponential growth of data; organizations require tools which interpret heavy data. Microsoft Business Intelligence products transform unadulterated data into insight data that keeps… Continue reading Unlock the power of Microsoft Business Intelligence Software to drive decisions by data
As the digital world continues to evolve, business leaders face constant pressure to make technology decisions that will position their organizations for success. One of the most critical decisions today is choosing the right data and analytics platform—one that is flexible, secure, cost-effective, and built for the future. Microsoft Fabric has emerged as a powerful,… Continue reading The Benefits of Moving to Microsoft Fabric: What Every Leader Should Know
In today’s fast-paced digital world, businesses are always looking for new ways to improve their data management. Before Microsoft Fabric technology came along, managing data was tough – there were silos, integration problems, and scalability issues. But with Microsoft Fabric, everything’s changed. Microsoft Fabric consultants are at the forefront of this revolution, guiding organizations to… Continue reading Revolutionizing Data Management with Microsoft Fabric Consultants
In the dynamic/diverse sphere of multi-sector businesses, it is essential to stay ahead in the market which requires strategic decision-making backed by insightful data analysis. Microsoft Business Intelligence (BI) emerges as a hero tool set in these diverse industries from empowering entrepreneurs to even large undertakings in order to unlock valuable business insights. Microsoft Business… Continue reading Microsoft Business Intelligence: A Game-Changer for Multi-Sector Business Owners
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
There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own drawbacks and cons that might not complement your requirements. Earlier we have posted blogs that describe the 4 approaches but as I said they have their own pre-requisite and cons. With the advancements of Power BI… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 5
As there are various approaches to embed Power BI Dashboard/Report in D365 Sales, we might often use a different approach to achieve it only to realize that it doesn’t suit our cost or requirements. We have posted blogs describing the other 3 approaches but they have their own limitations regarding licenses or restriction of data… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 4
We discovered several approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach came with certain pre-requisites or cons that might not complement our requirements. Blogs posted earlier regarding the other 2 approaches either need Power BI Pro License for each user or it doesn’t filter out data according to the users and… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 3
There are various approaches to share Power BI dashboard or report in D365 Sales and every approach has it’s own merits & demerits. Our previous blog describes an approach that doesn’t work if we need to restrict data from the users. I recommend you read through the previous blog first, to get the context. Now,… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 2
Microsoft Power BI enables its global users to share the Power BI dashboard or report by embedding them in various applications and sites. Likely, we can also share them in our D365 Sales using Publish to Web or Embed URL. There are many ways to achieve this, but not all approaches fulfill the requirement to… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 1
Nowadays, Power BI is used by many large organizations to collect information that helps their organization grow in the market. The increasing use of Power BI in such organizations, demands, mostly a development team that takes care of the reports’ development & deployment from A to Z. This demands the team to follow best practices… Continue reading Power BI > Development Cycle – DEV, TEST & PROD environments
We all know how the basic components in Power BI should work. But as soon as you think that now you have reached the stage where you know almost all about Power BI, it leaves you open-mouthed. Recently, I came across a very weird issue – “A BLANK row getting added to the Table from nowhere”… Continue reading Power BI > The magical BLANK row in table
Microsoft has released a very exciting feature – Conditional formatting by Field Value. Hence, we plan to explain how we took it’s best use with an example. There are times when we want to conditionally format a field that returns both text values and decimal numbers. To understand this better, let’s take some sample data… Continue reading Power BI > Conditional Formatting the Table > Use Case
Business Intelligence is one of the latest buzzwords that appear in the top trends in the businesses. As a result, a number of businesses have started exploring new business intelligence solutions like Microsoft Power BI offered by the Microsoft Power BI consultants India. But what Microsoft Power BI actually is and how it is powerful… Continue reading Importance Of Microsoft Power BI And How Can It Help A Business?
These days, we live in some hyper-connected world where information works as the key to success for both the businesses and individuals. But raw details contained in the data repository can actually make some clear sense and this is the place where the business Intelligence tools mainly come into the picture. Microsoft offers an entire… Continue reading Few Things About The Microsoft Business Intelligence Services
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2026
