User
Write something
Product & Community Updates is happening in 40 hours
Fabric Mirrored DB as copyjob source?
Has anyone manged to configure a copyjob using a mirrored (Azure SQL) db as a source? We finally got mirroring to work into our Bronze Layer and now want to copy to Silver but cannot see an option. We can run sql against the mirror end point just fine...
export data from Kusto database tables into warehouse tables using export SQL
I have two workspaces. I created Kusto database tables in the first workspace and Warehouse tables in the second workspace. Could you please help me copy the data from the Kusto tables into the Warehouse tables using the .export sql option? Any assistance would be greatly appreciated.
Lakehouse Write Permissions...
Hi All, I saw recently that you can now manage write permissions to a fabric Lakehouse and I am exploring to see if you can write from a PowerApp to a lakehouse? Currently trialling a fabric SQL server to run this and all works, but mindful around the CU consumptions from running this and curious if anyone has had any success writing from PowerApps to a Lakehouse? Keen to keep all the data within Fabric and avoiding the User Defined Functions route for writing to a Lakehouse for simplicity of the project.
Issue with Dataflow Gen2
I have a question, I want to ingest data from API's where I have to call multiple API's based on issue ID's to get the history from an issue and this history data is pretty long. To make my question/issue clear I don't want to give to many details about how I get the data but my setup is as this: I want to create a Dataflow Gen 2 that gets the data based on a watermark (date) value that I get from a SQL table (like for example yesterday 12/2/2025). so I created a scalar date value that I sould be able to use in my query to get only te new record. So in the query where I want to setup my table on the last step I add a filter to get all values from the WM date or after like this: Table.SelectRows( IssuesTyped, each [updated_at] >= WM ) In my powerquery I do get the results so I see for this example all history of the issues that are updated yesterday and today. But when I want to ingest this table into my datawarehouse I get a error: Error Code: Mashup Exception Expression Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: Failed to insert a table., InnerException: We cannot apply operator < to types Table and Date., Underlying error: We cannot apply operator < to types Table and Date. Details: Reason = Expression.Error;ErrorCode = Lakehouse036;Message = We cannot apply operator < to types Table and Date.;Detail = [Operator = "<", Left = error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForThrow(IThrowExpression throwExpr)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record", Right = #date(2025, 3, 5)];Message.Format = We cannot apply operator #{0} to types #{1} and #{2}.;Message.Parameters = {"<", "Table", "Date"};ErrorCode = 10051;Microsoft.Data.Mashup.Error.Context = User
0
0
Cross Reference Fabric Worksapce
Hey everyone! I have requirement where in we need to pull lakehouse and its tables from another workspace. I have found a function which is doing exactly I want. However it is using semy.fabric . I am not sure if this is productionize . Hence need some suggestions, if anyone is using this and ok to go ahead in Prod? fabric package = https://learn.microsoft.com/en-us/python/api/semantic-link-sempy/sempy.fabric?view=semantic-link-python function to call cross workspace and lakhouse = sandeep pawar, huge thanks 👍 for this. https://fabric.guru/quick-tip-using-notebookutils-to-get-fabric-lakehouse-properties
1-30 of 821
Learn Microsoft Fabric
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
Powered by