Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Dec 21, 2024

Best solution to improve performance of enterprise scale data

Hi Team, Calling Microsoft Fabric Experts! Need Your Guidance! Before the introduction of Microsoft Fabric, we relied on Dataflows Gen2 to connect to SQL sources, pull data, and transform it. For...
admin
BI & Data Analysis
developer
office 365
power bi
User Adoption
Kidd_Ip's avatar
Kidd_Ip
MVP
Dec 22, 2024

How about Using Existing Dataflows to Create Delta Tables

  1. Create a Lakehouse.
  2. Import Existing Dataflows to Create Delta Tables.
  3. Use These Delta Tables as the Source for Power BI Reports.

This option can improve report performance because:

  • Delta Tables: Delta tables in OneLake can optimize read and write operations, reducing latency and improving query performance.
  • Centralized Data: Consolidating dataflows into a Lakehouse ensures a more streamlined data management process.

Resources