Granting Permissions in a Fabric Data Warehouse and Lakehouse
We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses […]
Microsoft Fabric
KQL: The top of a group in an easy way
When learning something new, we always compare it with what we know. In this case, we end […]
T-SQL Notebooks: Manage Views Source Control and more
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
Microsoft Fabric et Google BigQuery
Dans le monde actuel axé sur les données, les organisations se retrouvent souvent avec d’énormes quantités de […]
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […]
Surveiller l’adoption des Microsoft Fabric Copilots
Cet article est disponible en Anglais sur LinkedIn : Monitoring Microsoft Fabric Copilot Adoption | LinkedIn. Les […]
Génération d’une dimension Date pour les modèles sémantiques en Direct ...
L’un des éléments clés d’un modèle sémantique est la table des dates. Elle fournit une référence pour […]
Contrôler la qualité des modèles sémantiques Power BI au fil ...
Cet article est disponible en Anglais sur LinkedIn : Monitoring the quality of Power BI Semantics Models […]
How to Stream Data from Azure Event Hubs into a ...
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for […]
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how […]
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
Suivi en temps réel de ma production solaire et de ...
Microsoft Fabric is a cloud-based platform that lets you, among other Data Activity, stream, analyze, and visualize […]
Empowering Lakehouse Users – Data Engineering with Fabric
Microsoft Fabric allows the developers to create delta tables in the Lakehouse. However, the automation of copying, updating, […]
Combining Silver Tables into a Model – Data Engineering with ...
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze […]
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, […]
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined […]
Metadata Driven Pipelines – Data Engineering with Fabric
What is a metadata driven pipeline? Wikipedia defines metadata as “data that provides information about other data.” As […]
PySpark Secrets to use with Fabric
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […]
Exploration Experience: Saving and Creating Datasets
I have been talking about Data Exploration in Power BI on many of my sessions, specially the […]
Full vs. Incremental Loads – Data Engineering with Fabric
The loading of data from a source system to target system has been well documented over the years. […]
Fabric and Azure SQL in a few clicks: Mirroring a ...
Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […]
Dynamic Partitioning and a Simple Incremental Load
Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode(« overwrite »).format(« delta »).partitionBy(« Year », »Month », »Day »).save(« Tables/ » + table_name) […]
Managing Files and Folders with Python – Data Engineering with ...
What is a data lake? It is just a bunch of files organized by folders. Keeping these files […]
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Microsoft Fabric, la solution décisionnelle pour toutes les entreprises – ...
L’événement de l’aMS de Strasbourg a eu lieu le 18 janvier 2024. Cette fois-ci l’événement a eu […]
Lancement de la chaine YouTube Data Chouette
Nous avons démarré une nouvelle chaîne YouTube pour les passionnés de données : https://www.youtube.com/@DataChouette Apprenez, explorez et […]
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
Storm Ciaran Analysis with Microsoft Fabric
Always looking for Open Source data to highlight the capabilities of Microsoft Analytics solutions, I have: In […]
Analyse de la tempête Ciaran avec Microsoft Fabric
Toujours à la recherche de données Open Source afin de mettre en exergue les capacités des solutions […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
Microsoft Fabric: Using notebooks and table partitioning to convert files ...
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […]
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […]
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark ...
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. […]
Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization
Learn how to provision Microsoft Fabric with ease! Unveiled at Microsoft Build 2023, Microsoft Fabric is a cutting-edge […]
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […]
What is OneLake in Microsoft Fabric?
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its […]
Meetup du Club Power BI, Hors-Série spécial Microsoft Fabric
Le 4 juillet 2023, le Club Power BI a organisé un nouveau Meetup titré « Hors-Série spécial Microsoft […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]