Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

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!

 

Need Help

6 Replies

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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 😞