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 new features they're working on and expected timelines they try to deliver it. I highlight the word try, because when Release 2021 wave 1 was announced, I got really really excited about the Workspace level refresh for datasets and dataflows as you can see here. Unfortunately,...
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, highlighting its journey from Excel and Power BI Desktop to Dataflows Gen1 and Dataflows Gen2. The discussion elucidated the differences in implementation and best practices. Read more about it here. Why We Used Dataflow Gen1 Before, Dataflow Gen1 was used to do transformations on...
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 in 2013 under the name of "Data Explorer", is a business user friendly tool to do data related duties in the ETL (extract, transform, load) realm. Tasks that otherwise were executed manually or with assistance of some VBA macro started to be easily available just a few mouse...
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 or a Warehouse in Microsoft Fabric. For this article, the focus will be on the LakeHouse workspace artifact item as a replacement for Power BI Dataflows, but it can also apply to the Warehouse item. If you're unfamiliar with SQL, don't worry, as this blog post aims to provide you...
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 from the source, then copy it again into the dataset (or other dataflows) before it's ready for consumption. Before that, data might have been provided to the Power BI user via a Data WareHouse that reads those data from a Data Lake... I think you got the idea. Multiple copies of...
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 integration to write DAX queries or help you with your report creation in the near future. Power BI Service will still receive updates to integrate with the monthly updates, and your Pro, Premium, and PPU licenses will continue to work exactly as before! In fact, Microsoft Fabric...
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 communication platform to also reach those who prefer to read. In this space, I'll share my thoughts in both Portuguese and English. Here, I'll delve into all things data-related, along with thoughts that often get lost in my memory due to lack of a larger audience to share them with....
Recent Comments