Forum Discussion

sstockda's avatar
sstockda
Regular Visitor
4 years ago
Solved

Incremental refresh on Datamart - Error

Hi,   I've configured a table in a Datamart to extact data from a PostgreSQL database via n On Prem Data Gateway. If I do a full load I can grab all the data which is abuot 1.7M rows - its a little...
Dataflow
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Maximum_Attakk ,

    We have reproduced your issue and have submitted to internal icm 311746938 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

    Best Regards,
    Community Support Team _ kalyj

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Have you been able to fix that? I have exactly the same error and my connections are done to XLSX files as sources. This only happens when I try to set up incremental refresh for my data mart so purely seems to be associated with Azure SQL limitations which are used for data mart data hosting. Apparently I also noticed that TSQL hangs when done against large data arrays. Even a simple select * from table may hang when issued againsta a table with a few million rows. Originally my thought that this is somehow connected with direct query limitations but whats the point of having data marts then if they can't be used for large data tables? So doubdtful, still no answer.