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 slow so I'd like to configure Incremental refresh. 

 

When I hit the apply button after configuring Incremental refresh options the loading data box pops up and then after about 20 mins I get the following error: 

 

I've seen others are facing similar issues as well. 

 

Thanks,

 

Simon

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

8 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi sstockda ,

    This error usually means that the client can't find the SQL Server instance. This issue occurs when at least one of the following problems exists:

    • The name of the computer hosting SQL Server is incorrect.
    • The instance doesn't resolve the correct IP.
    • The TCP port number isn't specified correctly.

    This official document provide detailed steps to troubleshoot the error, please refer to it.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • sstockda's avatar
      sstockda
      Regular Visitor
      4 years ago

      Hi, 

       

      I'm not connecting to a SQL Server database. As I said I'm connecting to a PostgreSQL database. My guess is that the SQL database the error is talking about is the SQL instance behind Datamart. 

       

      Simon

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Community Support
        4 years ago

        Hi sstockda ,

        I think so, when you create a Power BI Datamart, Three objects behind the scene is created; A dataflow, an Azure SQL database, and a Dataset. Some of these components are exposed as individual components, but some are hidden.

        In this blog, there're steps about how to see the SQL database in the datamart: Power BI Datamart Components 

        Best Regards,
        Community Support Team _ kalyj

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

  • Maximum_Attakk's avatar
    Maximum_Attakk
    Frequent Visitor
    4 years ago

    I have pretty much the same issue reading data from and Oracle db. I picked the smallest table I coould to test this and if I read the whole table in there's no issue but as soon as I set up incremental refresh it just hangs and eventually fails. Some of the tables I want to include have 10s of millions of rows in them so I need to get this resolved before trying to create my datamart.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    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.