Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Louis Davidson in Other Lies you should believe: There are no dumb ideas When I was a brainstorming ideas for a series of posts, it took me back to a brainstorming session we... 22 March 2024 3 min read
Other Dennes Torres in Other 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
Other Sheila Romans in Other The Benefits of Volunteering at SQL Saturdays How it all started After attending PASS Summit in 2022 my husband set a goal to speak at as many... 14 March 2024 5 min read
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Simple Talk Editor in Other Writing your 2024 PASS Data Community Summit Submission It is time again for the PASS Data Community Summit Call For Speakers. Some of you are very ready. You... 05 March 2024 10 min read
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Louis Davidson in Other Planning, the First Step To Failure You probably have heard the saying “if you fail to plan, you plan to fail”. I get the sentiment here,... 09 February 2024 4 min read
Other Simple Talk Editor in Other Adding a new AI usage policy to Simple-Talk I used to think plagiarism was my worst thing to deal with as an editor. That is only sort of... 26 January 2024 5 min read
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Louis Davidson in Other Working on Technology Off the Clock I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have... 16 January 2024 3 min read
Other Dennes Torres in Other 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
Other Louis Davidson in Other Being A Bit Less Comfortable in 2024 I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple... 03 January 2024 3 min read
Other Dennes Torres in Other Fabric Notebooks and Deployment Pipelines On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on the source control.... 13 December 2023 8 min read
Other Louis Davidson in Other What Counts For a DBA: Duty It has been a long month. We had the PASS Data Community Summit just a month ago, and I came... 08 December 2023 3 min read
