In the self-service part of the BI from microsoft, the only ETL tool available for regular business users is Power Query via Power BI or Excel. It is a no/low-code interface with hundreds of built-in connectors to easily extract and transform your data. While there...
Renato Lira
Exploring Alternative Methods for Implementing Workspace-Level Refresh in Power BI and Fabric
In this blog post I'll talk about alternatives to achieve Workspace Level Refresh in Power BI and Fabric, by using the new available item Data Pipelines or an approach that uses Power Automate to achieve this goal. From time to time Microsoft announces its intents to...
Dataflow Gen2: A Superior Alternative to Power BI Dataflow for Data Sharing
In this blog post, we'll delve into how Dataflow Gen 2 can enhance performance, especially if you're currently facing challenges with Dataflow Gen1's performance. Looking Back at Power Query I've touched upon the evolution of Power Query in a previous post,...
The Evolution of Power Query from a User-Friendly Data Transformation Tool to Dataflow Gen2
A brief history with best practices of Power Query and why Dataflow Gen 2 is a big deal towards separating the E, T and L to enhance compute power and flexibility to your complex data preparation process. Introduction Power Query, which debuted as an Excel add-in back...
Data Security Best Practices: Implementing OLS and RLS in Microsoft Fabric
This blog post could be called "A better solution for Power BI Dataflow Sharing per Workspace," as it takes a "Power BI" perspective but delves deeper into implementing OLS (object-level security) and/or RLS (row-level security) to share data through the SQL Endpoint...
Revolutionizing Power BI: The Road from Multiple Copies to Microsoft’s OneLake and Beyond
In the world of data analytics, the persistent challenge of copying and moving data across multiple tools is a significant hurdle. Within the scope of Power BI Service, the furthest upstream landing place for external data involves the use of a Dataflow to copy data...
Microsoft Fabric is the best Power BI upgrade so far!
So, what happens to the Power BI folks? Nothing changes. You can think of Microsoft Fabric as a Power BI upgrade that gives even more capabilities to upstream workloads. Power BI Desktop will continue to be updated monthly, including announced features like copilot...
Unveiling My Thoughts: The Inception of My Blog
I've decided to launch a blog! After some time participating as a speaker at external and internal events at Petrobras, and sharing videos on YouTube through PlanilheirosBrasil, under the guidance of the esteemed Fernando Garcia, I've chosen to diversify my...
Recent Comments