Microsoft

SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]

  SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications. […]

Introduction:  Power BI’s merging and appending operations allow you to join data from multiple tables.  The choice between the merge and append queries depends upon the type of concatenation you want to carry out based on your requirement. When you have one or more columns that you’d like to add to another query, then you […]

Overview: A Data Factory or Synapse Workspace can have multiple pipelines. Pipelines are groups of activities that perform a specific task together. Data integration and ETL (Extract, Transform and Load) services in the cloud work together to orchestrate data movement and transform data with ease. There are workflows that can ingest data from disparate data […]

I will be sharing my personal experience with learning Power BI and clearing the PL-300 (Earlier called DA-100) exam. I hope this will help the other aspirants. I would not be compromising the signed NDA; hence no questions will be disclosed in this article. About the Exam : PL-300: Microsoft Power BI Data Analyst Analyzing […]

What is RLS?  RLS is Row Level security means restriction of data accessing for a particular user. Filters restrict the data at a row level. We can configure RLS for a dataset that we have imported into the Power BI desktop and can configure RLS in Power BI Service by defining the roles in the […]

Paginated Reports are the same as SSRS, which have come to Power BI with advanced features for better reports. Paginated Reports are well designed & formatted reports which are perfectly sized so we can print and share the reports effectively. We can also load images and charts on these reports. We can create highly formatted […]

A significant driver for needing to change platforms is when your business undergoes a significant digital transformation effort. Typically, a company chooses to undertake a digital transformation because they need to change the experiences their customers have with their brand. Usually, that means some amount of change in systems in order. Reason #5: Your Business […]

The following is the first in a series of blogs on Power Platform Dataflow.  ETL, Data Integration, and Data preparations are the backbone of any business application. Enterprises today generate a massive amount of data in their day-to-day operation. Moreover, this data is messy and comes from different sources and locations, each with its unique […]

This article will look at the implementation of client side scripts on Microsoft Dynamics 365 using a model-driven approach, which provides additional benefits on the UI level and allows us to easily access Form UI properties such as tabs, sections, fields and access, security role, complex validations and so on. So, here in Dynamics 365, […]

The problem statement: An organization having a lot of FMCG products, conducts campaigns in various cities across India. The main aim of this campaign is to promote the products and collect feedback from the customers both existing and prospective ones. The data is collected in excel files and loaded to a centralized location in the […]

As we know, one of the major limitations of PowerApps (Canvas mode) is that it does not allow multiple developers to work at the same time on the same app, but this Software as a Service (SaaS)-based app continues to supply new features and releases every year in April and October. The PowerApps technical team […]