Experimenting with Copy Job. Yeah, OK, but not great. Some suggestions:
1) Make the option for OVERWRITE available for Warehouse destinations. Currently available for Lakehouses only. This article ...
ToddChitt
Super User
2 months agoThe documentation on this item: (https://learn.microsoft.com/en-us/fabric/data-factory/what-is-copy-job) mentions this:
You can also optionally truncate destination data before the full load, ensuring your source and destination are fully synchronized without duplicates.
By default, Copy job doesn't delete any data in destination. When you enable this option:
The first run of incremental copy will truncate all data in the destination before loading the full dataset.
Why is there NOT an option to TRUNCATE on a FULL load? This is a basic requirement. I'm willing to bet that when they were developing this thing, they worked on the FULL load part of it first. If I were the PM overseeing this, IT WOULD NOT HAVE BEEN MARKED COMPLETE UNTIL A TRUNCATE OPTION WAS MADE AVAILABLE TO THE USER!!!
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael1 hour agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor3 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1813 hours agoNew MemberNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx15 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell16 hours agoNew MemberNew15Views2likes0Comments