Arabic
French
Spanish
Fabric SQL Database – First look SQL Database as an item in Fabric workspace – a significant development that happened ever since the introduction of Fabric. From SQL Database perspective as well, it is a major milestone since it is now available as a SaaS. Bells and whistles apart, we took a closer look into […]
We are the Best Consulting web site as part of the annual WebAward Competition!
The Power of Partitioning: Efficient Data Management with Microsoft Fabric
The Power of Partitioning: Efficient Data Management with Microsoft Fabric In today’s data-driven world, managing large datasets efficiently is crucial for maintaining performance and ensuring seamless operations. One way to achieve this is through data partitioning. In this post, we’ll explore how I handle New York taxi data spanning from 2016 to 2018 using partitioning […]
Advanced Dataflow Backup Strategies for Microsoft Fabric & Power BI Using PowerShell
Advanced Dataflow Backup Strategies for Microsoft Fabric & Power BI Using PowerShell Introduction Version control is a vital aspect of managing any dynamic system, especially when it comes to data workflows. As organizations increasingly rely on Power BI for business intelligence, ensuring that your dataflows are backed up regularly and versioned correctly becomes critical. However, […]
Authenticating using Service Principal in Microsoft Fabric SQL Endpoint
Microsoft Fabric provides SQL Endpoint on Lakehouse and Warehouse through which we can run SQL queries and Stored Procedures on the stored data. Whenever we run SQL statements, they need to be authenticated by a principal so that the SQL Engine can check whether the principal is authorized to access and execute statements. But unlike […]
Data Engineering in Microsoft Fabric: Part 4 – Orchestration
Data orchestration is an automated way to manage and organize data from different sources, making it ready for analysis. It’s also known as data pipeline orchestration or data workflow orchestration. This process covers many parts of data management, such as ensuring data quality, following data rules (governance), and automating various tasks. It also handles moving […]
Data Engineering in Microsoft Fabric: Part 3 – Transformation – Stored Procedure
Are you writing the same SQL code repeatedly? Thinking of a way to reuse the code? If yes, then you have come to the right place! Or if you want to know about stored procedure and how to create/execute them, this article is for you as well. A stored procedure is a group of SQL […]
Leveraging MSSparkUtils for file operations in MS Fabric
Microsoft Fabric is an all-in-one analytics solution for enterprises that helps you create, use, and govern data insights across your organization. In the context of Fabric, Spark integration enables developers to leverage Spark’s capabilities for big data processing within the Fabric ecosystem. Spark is a powerful open-source distributed computing framework that specializes in scalability, speed, […]
Data Engineering in Microsoft Fabric: Part 2 – Ingestion – Dataflow Gen2
Dataflows is a collection of tables that perform data transformation in Power BI services independently. It leverages the Power Query engine with a common data model to do the required transformations and make it available for reuse by different dataflows and the Power BI semantic model (previously known as a dataset). Transformation is essential not […]
Stay ahead in a rapidly world. Subscribe to Prysm Insights,our monthly look at the critical issues facing global business.
[mc4wp_form]
© 2024 Data Crafters | All rights reserved