Koen Verbeeck in BI 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 of the existing... 10 June 2024 20 min read
Dennes Torres in Blogs Purview and Microsoft Fabric: Better Together Microsoft create Purview, a data governance solution. Since Microsoft Fabric was in preview, there was a promise of a deeper... 29 May 2024 2 min read
Blogs Dennes Torres in Blogs The Evolution of Time Travel in Fabric Data Warehouse The May Microsoft Fabric updates bring new about Time Travel in a Data Warehouse. This is good but surprising because... 24 May 2024 3 min read
Blogs Dennes Torres in Blogs Workspace Identity and Resource Instance Rules: More than simple features Sometimes, when a new feature is announced, it’s in fact hiding bigger changes on the entire environment. This is exactly... 22 May 2024 3 min read
BI Fabriano Richard in BI 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, which in its... 13 May 2024 12 min read
Blogs Dennes Torres in Blogs Edit The JSON of a Fabric Pipeline A Fabric Pipeline uses JSON as source code. They are also saved in repositories as JSON. We first idea we... 08 May 2024 1 min read
Koen Verbeeck in BI 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 software engineering approach.... 06 May 2024 11 min read
Blogs Dennes Torres in Blogs 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 them. Control the... 30 April 2024 3 min read
Blogs Dennes Torres in Blogs 4 Reasons to use KustoDB for Real-Time When implementing real-time ingestion, we usually implement an architecture called lambda. Using the lambda architecture, KustoDB in Microsoft Fabric is... 23 April 2024 2 min read
Blogs Dennes Torres in Blogs Exploration Experience: Saving and Creating Datasets I have been talking about Data Exploration in Power BI on many of my sessions, specially the sessions about Data... 17 April 2024 2 min read
BI Dennes Torres in BI Fabric and Azure SQL in a few clicks: Mirroring a Database Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake... 12 April 2024 11 min read
Blogs Dennes Torres in Blogs 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) Let’s consider we... 03 April 2024 2 min read
Blogs Dennes Torres in Blogs Creating a Single JSON File for Configuration using Notebooks On the blog Fabric Notebook and Deployment Pipelines I explained a technique to keep notebooks configuration values in JSON files... 27 March 2024 2 min read
Blogs Dennes Torres in Blogs 5 Secrets about Dataflows Gen 2 Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the... 13 March 2024 5 min read
Blogs Dennes Torres in Blogs 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 use the PBIP... 06 March 2024 3 min read
Blogs Dennes Torres in Blogs Customizing Kusto (Data Explorer) Connections in Deployment pipeline When organizing our SDLC (Software Development Lifecycle) in Power BI/Fabric, we use Deployment Pipelines and create rules to change connection... 28 February 2024 2 min read
Blogs Dennes Torres in Blogs Eventstream and the new KQL Processing Eventstream has many differences in relation to the technologies it proposes to replace. Event Hub, Stream Analytics, Streaming Dataflows and... 21 February 2024 2 min read
Blogs Dennes Torres in Blogs 4 Rules to follow on Microsoft Fabric Source Control Power BI and Fabric are implementing source control support. It’s a long-awaited feature for Power BI. However, it’s important to... 14 February 2024 4 min read
BI Dennes Torres in BI 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 data... 25 January 2024 9 min read
Blogs Dennes Torres in Blogs Power BI and Resource Graph: Why you should care Recently Azure Resource Graph was announced as a new connector in Power BI. Azure Resource Graph provides access to almost... 23 January 2024 1 min read