cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sstockda
Regular Visitor

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: 

 

sstockda_0-1655122236725.png

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

 

Thanks,

 

Simon

1 ACCEPTED SOLUTION
v-kalyj-msft
Community Support
Community Support

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

View solution in original post

7 REPLIES 7
vizar853
New Member

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.

v-kalyj-msft
Community Support
Community Support

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

Maximum_Attakk
Regular Visitor

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-kalyj-msft
Community Support
Community Support

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.

 

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

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.

 

Hi @v-kalyj-msft ,

 

As interesting as it is to know how things work behind the scenes I'm still stuck looking at an error message that's nothing to do with any of my systems. 

 

Any ideas how we resolve the problem? I'm just trying to configure Increment Refresh by ticking boxes. 

 

Thanks,

 

Simon

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors