cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Error in Incremental Refresh

Hi @all,

 

It's glad to hear that pwbi had support incremental refresh for pro user.

 

I had tried this function last week. But it seems not to work for me. 

Here is the detail:

I got 1 file, and duplicate each other and set up in different refresh methods

File 01:

- Traditional methods in refresh

- Full dataset (16 million data rows)

- Full reports and chart

- File size: 144MB

=> Refresh success, and take around 60 - 90 minutes for each refresh

Here is the result

pic 1.PNG

 

File 02:

- Incremental refresh applied

- Same dataset (16 million datasets)

- Full reports and charts

- File size: 21 MB

=> Can not make the 1st successful refresh. It always shows this below error:

bug 3.PNG

 

File 03:

- Incremental refresh applied

- Same dataset (16 million datasets)

- No reports, chart or DAX

- File size: 200Mb

=> Success in refreshing

Here is the picture

pic 2.PNG

 

I know that it will take a long time for the 1st run. But my consider is, why with the same dataset (16 mil rows), File 02 is not success in increment refresh?

 

Please help me to solve this problem. Thanks in advance!

 

6 REPLIES 6
Highlighted
Resolver III
Resolver III

@thangtruong So it said it has timed out. My first question would be what is the data source and if it actually can time out?

Highlighted

@JirkaZ hi, thank you for your reply.

 

For the 1st question, I connect Pwbi with SQL Server, and using IMPORT method (not DIRECT QUERY)

For the 2nd question, as I show in my post, the 1st FILE (with full dataset, full reports, and DAX) takes 60 - 90 mins, which means it not reach 2 hours.

 

Hope you're going well.

Highlighted

Have you tried refreshing that 2nd file more than once?  It would be nice to rule out whether your timeout wasn't simply a coincedence.  There can be other stuff going on in your network that can cause you to have a timeout under normal circumstances.

Highlighted
Community Support
Community Support

Hi @thangtruong ,

 

x5.PNG

For the issue, please refer to efore the data import for finished, its data source timed out  .

cc12.PNG

 

Best regards,
Lionel Chen

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

Highlighted
Community Support
Community Support

Hi @thangtruong ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

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

Highlighted

@v-lionel-msft 

Thanks for your response

I already try all the methods that I can find in the web, or in this community. But nothing works.

Now I'm working with Power BI Customer's Support (some guys in India) and we are trying to figure the problems out.

Will update to all you guys about my case 😞

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors