Forum Discussion
Read data from Dataverse table via Fabric Dataflow gen 2
Looks like this is the same issue as
Gen2 Dataflow load to Lakehouse error - Can't inse... - Microsoft Fabric Community
"
Exception:ExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Message: We can't insert null data into a non-nullable column."i.e., your source\destination target has nulls but the columns are non-nullable.You can mark your source table's columns to nullable to fix this for now. We are working on several changes here that will address the issue - such as defaulting to nullable, and surfacing nullability better in the mapping screen.
Hi NandanHegde
Thanks for using Fabric Community.
Can you please copy and paste the entire error message here?
Thanks
Error Msg :
Error Code: 104100, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Failed to insert a table., InnerException: #{0}: #{1}, Underlying error: Microsoft SQL: The timeout period elapsed prior to completion of the operation or the server is not responding. RequestId: TDS;7ef36592-e05d-4fa4-aba4-2867211f2ce5;17 Time: 2024-02-14T10:42:17.9260565Z Details: Reason = DataSource.Error;Message = Microsoft SQL: The timeout period elapsed prior to completion of the operation or the server is not responding. RequestId: TDS;7ef36592-e05d-4fa4-aba4-2867211f2ce5;17 Time: 2024-02-14T10:42:17.9260565Z;Detail = [DataSourceKind = "CommonDataService", DataSourcePath = "avanadeuat.crm.dynamics.com", Message = "The timeout period elapsed prior to completion of the operation or the server is not responding.#(lf)RequestId: TDS;7ef36592-e05d-4fa4-aba4-2867211f2ce5;17#(lf)Time: 2024-02-14T10:42:17.9260565Z", ErrorCode = -2146232060, Number = 40001, Class = 16, State = 1];Message.Format = #{0}: #{1};Message.Parameters = {"Microsoft SQL", "The timeout period elapsed prior to completion of the operation or the server is not responding.#(lf)RequestId: TDS;7ef36592-e05d-4fa4-aba4-2867211f2ce5;17#(lf)Time: 2024-02-14T10:42:17.9260565Z"};Microsoft.Data.Mashup.Error.Context = User (Request ID: c45326c6-6658-41a0-ba0d-1adf5c1d1648).Hi NandanHegde
Can you please try to disable the staging of power query? This might solve the issue.
If you are still facing the issue please do let me know.
Thanks.Did that but still getting the error but now the error message is not present :
