Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Excel not refresh on Gateway

Hi!

 

I'm using a Excel file (material stock) into my power bi report.

 

Excel file must be updated everyday.

 

When I refresh excel using power bi desktop it works ok so I have configured the excel on gateway:

Then I scheluded the refresh and it resports that it was ok but report is not updated!!!

 

 

Report show data from excel that I publish last time.

 

Report shows the excel data that I uploaded when I published the report the last time and it is never refreshed from the gateway.

 

But gateway doesn't show any error on refresh.

 

any help?

 

Regards

 

 

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    I'm not sure I understand you correctly.
    After the Excel file is saved and the dataset is manually refreshed in the service, then the modification date of the Excel file stays before the refresh date.
    Are you saying that when you open Excel and then save, the data in the service is automatically refreshed without having to manually refresh the dataset in the service again?

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      amitchandak, yes, file name is equal but content is completly different: different row numbers, amounts, etc.

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        Anonymous , In power query , when you right-click on table there is option , to refresh is incremental load , check if that is enabled

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    If the refresh time of the data set is updated, then I believe you refreshed successfully.

     

    Note that when you refresh the dataset, the visual will not refresh dynamically so you will need to manually refresh the page or click on the "Refresh visuals"  at the top bar for you to see the updated report.

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    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
      4 years ago

      v-angzheng-msft No, I refresh and data are not updated. 

       

      I think it is because of Excel "Date modified" is before last refresh date.

       

      If I open excel and save it (with no modification) then power bi refresh data.

       

      ¿Is there any way to force to read current excel?

       

      Un saludo