Dennes Torres in Blogs Data and SaaS : Who owns your company’s Data? On the era of SaaS, I see many companies hiring a lot of SaaS services. They create a dependency on... 15 May 2024 2 min read
Blogs Louis Davidson in Blogs T-SQL Tuesday #174: Your Favorite Job Interview Question? T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for this months topic,... 14 May 2024 8 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
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
Blogs Dennes Torres in Blogs Azure OpenAI and RAG Security The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and Cloud Security: Secure... 10 April 2024 3 min read
Ben Johnston in Culture Building a Culture of Data One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My... 04 April 2024 19 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 Louis Davidson in Blogs 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
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 Sheila Romans in Blogs 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
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 Simple Talk Editor in Blogs 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
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
Blogs Louis Davidson in Blogs 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
