Forum Discussion

NandanHegde's avatar
NandanHegde
Super User
2 years ago
Solved

Read data from Dataverse table via Fabric Dataflow gen 2

Hello All, Good day!   I am trying to read data from dataverse tables through Farbic dataflow : https://learn.microsoft.com/en-us/fabric/data-factory/connector-dataverse   But getting timeout e...
Need Help
  • pqian_MSFT's avatar
    pqian_MSFT
    2 years ago

    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=31bf3856ad364e35
    Message: 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.
NandanHegde's avatar
NandanHegde
Super User
2 years ago

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).

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.