How to extract the values of rowsCopied and rowsRead from the below Copy activity output in Fabric and store in Fabric Warehouse to maintain the log table of rowsCopied and rowsRead in fabric warehouse { "dataRead": 5480, "dataWritten": 5680, "filesWritten": 1, "sourcePeakConnections": 1, "sinkPeakConnections": 1, "rowsRead": 30, "rowsCopied": 30, "copyDuration": 24 }

Incremental ingestion in Fabric Notebook I had question - how to pass and save multiple parameter values to fabric notebook. For example - for the below code how to pass 7 values for table in {Table} parameter sequentially and after every run need to save the last update date/time (updatedate) column values as variables and use these in the next run to get incremental values for all 7 tables. Notebook-1 -- 1st run query = f"SELECT * FROM {Table}" spark.sql (query) --2nd run query-updatedate = f"SELECT * FROM {Table} where updatedate > {updatedate}" spark.sql (query-updatedate)

Hi , I had question for Fabric Lakehouse. How to create different environments (test/dev/prod) for lakehouse for the same Workspace and how to create different environments for tables (test/dev/prod) for lakehouse-tables.

I have a question while trying to add WorkSpace Role Assignment through Fabric Rest API, but getting the below error. In the id , adding the Client-id of Service principal (App-Registrations Azure). Can anyone guide in it. URL - POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/roleAssignments Fabric Rest API link - https://learn.microsoft.com/en-us/rest/api/fabric/core/workspaces/add-workspace-role-assignment?tabs=HTTP#serviceprincipalprofiledetails $WorkSpaceRolePayload = @{ principal = @{ "id" = "client-id" "type" = "User" } role = "Member" } Write-Host "WorkSpaceRolePayload" : $WorkSpaceRolePayload Error - { , "errorCode": | "PrincipalNotFound", "moreDetails": [ { "relatedResource": { | "resourceId": "xxxx", | "resourceType": "Principal" } } ], "message": "The | provided principal was not found", "relatedResource": { | "resourceId": "xxxx", | "resourceType": "Workspace" } }