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 Model Optimization: Available In MDX Property Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and... 20 March 2024 3 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
Ben Johnston in Blogs Feature Flags in Data Projects My motivation for writing this summary was an interaction with a project owner that didn’t understand why we couldn’t use... 01 February 2024 23 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
Blogs Dennes Torres in Blogs Fabric and Self-Service: Control who can use We can say Fabric is the evolution of the Power BI environment. Power BI is a self-service environment, and so... 17 January 2024 2 min read
Blogs Dennes Torres in Blogs 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 since SQL Server... 10 January 2024 3 min read
