Koen Verbeeck in General Analytics A gentle introduction to dbt In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract... 10 December 2024 12 min read
Dennes Torres in Microsoft Fabric 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 in Fabric. We... 04 December 2024 4 min read
Dennes Torres in Blogs 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 up comparing KQL... 13 November 2024 3 min read
Dennes Torres in Blogs Analyzing Kusto Query History in Fabric We can consume a Kusto database in Fabric from many different places: Notebooks, semantic models, real time dashboards and more.... 07 November 2024 5 min read
Dennes Torres in Blogs 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 the fact this... 31 October 2024 3 min read
Dennes Torres in Blogs Shortcuts, Capacities and Costs : Some Considerations Edit on 25/10/2024: According to some official documentations, there is an inaccuracy on this blog. The costs involved on data... 23 October 2024 3 min read
Microsoft Fabric Dennes Torres in Microsoft Fabric Using a Service Account in Microsoft Fabric Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA... 16 October 2024 4 min read
Koen Verbeeck in BI Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster Power BI has been a leading data visualization tool in the market for years. It can be used as a... 11 October 2024 13 min read
Dennes Torres in Blogs Cloud Connections in Microsoft Fabric I wrote about cloud connections when they were in a very early stage. Cloud connections evolved and are now sharable.... 09 October 2024 4 min read
Dennes Torres in Blogs Debugging DAX with DAX Query View DAX Query View was created some time ago and it was a great tool to run DAX inside Power BI... 25 September 2024 3 min read
Dennes Torres in Blogs Infinity Notebook Loop in Fabric using Data Activator Data Activator allow us to make an interesting workaround for infinity notebook executions. Infinity execution loop is interesting for constant... 20 September 2024 4 min read
Dennes Torres in Blogs Data Activator: The secrets of monitoring alerts Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and... 11 September 2024 2 min read
Dennes Torres 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 about loops before. Let’s... 04 September 2024 4 min read
Dennes Torres in Blogs PySpark: The flexibility of a loop Pyspark has many flexible syntaxes which are not so common to other languages. One of these syntaxes is the loop... 15 August 2024 3 min read
Dennes Torres Microsoft Fabric: Using Lakehouse data in Real Time Dashboards Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default it’s made... 08 August 2024 2 min read
Blogs Dennes Torres in Blogs Microsoft Fabric: Differences Between %Run and Notebook.Run When developing notebooks in Microsoft Fabric, we have two different methods to call one notebook from another: %Run and MSSparkUtils.notebook.run... 31 July 2024 2 min read
Koen Verbeeck in BI How to Stream Data from Azure Event Hubs into a Fabric Eventhouse At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This... 26 July 2024 9 min read
Dennes Torres in Blogs Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces Dataflows Gen 2 are not supported by source control and deployment pipelines yet. When we need to promote a dataflow... 17 July 2024 2 min read
Dennes Torres in Blogs Microsoft Fabric: New Features you should not miss Microsoft Build was full of new features announcements and the fact it was so close to the Fabric May Updates... 10 July 2024 2 min read
Dennes Torres in Blogs Real-Time Intelligence: More than a name change When everyone starts to announce Real-Time Intelligence in Microsoft Fabric as something new, I need to double check what’s happening:... 03 July 2024 5 min read
