Fabriano Richard in BI 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 it came about... 03 July 2024 9 min read 1
Dennes Torres in Blogs Fabric: The Secrets of Capacity Consumption Fabric Capacity consumption is exposed to us through a Power BI app called Fabric Capacity Metrics. We need to install... 19 June 2024 4 min read
Blogs Dennes Torres in Blogs Microsoft Fabric: Ingesting from API’s and the JSON result Ingesting from API’s is a common task to build a Data Intelligence repository. When making this ingestion in a Fabric... 12 June 2024 7 min read
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 Power BI Available In MDX: Model Optimization Optimize Power BI semantic models by disabling the Available In MDX property on unused fields. Reduce PBIX file size, memory... 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