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 error :

 
 

 

 

 

So how to check the logs on dataverse side and whether the timeout is on dataverse side or dataflow capacity issue and what actions should be taken?

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.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi NandanHegde 
    Thanks for using Fabric Community.
    Can you please copy and paste the entire error message here? 
    Thanks

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