Error in Incremental Refresh

[Anonymous]

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

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:

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

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!

[v-lionel-msft]

Hi @Anonymous ,

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.

[Anonymous]

@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 😞

[v-lionel-msft]

Hi @Anonymous ,

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

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.

[JirkaZ]

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

[Anonymous]

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

[Anonymous]

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.