CopyJob for SAP Datasphere ADLS2 connection requires SAS authentication support
Description
Currently, when configuring a Copy Job using the SAP Datasphere Outbound for ADLS2 source, the UI does not provide an option for Shared Access Signature (SAS) authentication to the underlying ADLS Gen2 storage account. This forces users to provide an Account Key (Full Access), which contradicts enterprise security standards of least privilege.
The Inconsistency
There is a clear functional discrepancy within Microsoft Fabric:
Lakehouse Shortcuts: Correctly allow SAS authentication when creating a shortcut to the same ADLS2 storage.
Standard ADLS2 Connections: A standalone ADLS2 connection in a Copy Job or Pipeline allows SAS authentication.
SAP Datasphere Outbound connection in Fabric: When selecting this specific connection type in a Copy Job, the UI restricts the authentication methods, omitting SAS.
Why This Is Critical
Security & Compliance: SAP Datasphere itself supports and recommends SAS tokens for writing to ADLS2 storage. By not supporting SAS on the Fabric side for the same connection, Fabric becomes the "weakest link" in the chain, requiring "all or nothing" Account Keys.
Enterprise Readiness: Large-scale SAP integrations require granular, time-bound access. Using Account Keys for staging containers is often rejected by InfoSec teams.
Workflow Efficiency: Users already have the infrastructure (SAS tokens) generated by SAP Datasphere. Requiring a different credential type specifically for the Fabric Copy Job adds unnecessary friction.
Proposed Solution
Expose the "Shared Access Signature (SAS)" authentication kind within the connection settings for SAP Datasphere Outbound sources in the Copy Job UI, achieving parity with the standard ADLS Gen2 connector.
Recent ideas
Fabric App (Rayfin): support for Service Principal authentication
Hi, about Fabric Apps it is very important to implement and release the Service Principal authentication as soon as possible, in order to evolve related Fabric solutions towards enterprise ones! Ma...pmscorca1 hour agoPost ProdigyNew4Views1like0CommentsDatabricks Autoloader equivalent for Fabric Lakehouse
We need something low code close to autoloader of databricks in Fabric, which is built on top of structured streaming, that can load data incrementally from lake files in ADLS/One Lake into lakehous...Gaurav_Batta2 hours agoNew MemberNeeds Votes1.4KViews30likes3CommentsAllow Power Query to temporarily skip a step (turn a query step on and off)
It would be nice to have an option/button/toggle that would allow the query to temporarily skip a step. For example, if you are testing a query it would be nice to be able to toggle a filter step on...EHA_SD4 hours agoAdvocate IVNew5Views0likes0CommentsImprove Copy Job Validation Errors When Upsert Keys Are Missing
Improve Copy Job Validation Errors When Upsert Keys Are Missing Product: Microsoft Fabric Area: Data Factory – Copy Job Category: Error Handling / User Experience Problem When adding new tables ...jasonhorner10 hours agoRegular VisitorNew5Views0likes0Comments