Forum Discussion

kakenned's avatar
kakenned
Frequent Visitor
1 year ago
Solved

Excel Web API refreshing successfully, but data not updating

I've searched for an answer to this but haven't found anything, so sorry if this has been answered somewhere already.   I have two different reports that I'm having this issue with. I have excel fi...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, lbendlin , for your response.

    Hi kakenned,

    We sincerely appreciate your inquiry on the Microsoft Fabric Community Forum.

    In addition to the response provided by lbendlin , please follow the steps mentioned below, which may help resolve the issue:

    1. Open your Excel file, navigate to Formulas > Calculation Options, set it to Automatic, and ensure that Power Query steps (such as DateTime.LocalNow()) refresh properly when using Refresh All. Save the file and re-upload it to SharePoint.

    2. Create a flow to run on Sunday at 11:30 PM EST. Use Excel Online (Business) > Run Script with a script that forces recalculation. Then, add Power BI > Refresh a Dataflow to update the data immediately after execution.

    3. In Power BI Service, ensure that the dataflow refresh schedule is aligned with the flow and is not caching outdated data.

    4. Execute the flow and dataflow on Sunday night, and verify the report on Monday morning to confirm that it displays the correct data for last week.

    Additionally, please refer to the links below for further assistance:
    Power Query SharePoint folder connector - Power Query | Microsoft Learn
    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

    If the solution did not resolve the issue, we kindly request you to raise a support ticket using the link:Microsoft Fabric Support and Status | Microsoft Fabric

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

    Thank you.

kakenned's avatar
kakenned
Frequent Visitor
1 year ago

Ok I will try that connector out. 

 

We are EST so either 4 or 5 hours behind UTC depending on the time of the year. The time difference shouldn't matter in this case, as it's excel that isn't updating and excel uses the system date. So whenever it hits midnight and that new week is in effect it shouldn't care that the service is on UTC because it's also a new week on that time also. Am I thinking about this correctly?