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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi kakenned,

We are following up once again regarding your query. Kindly confirm whether the issue has been resolved through the support ticket with Microsoft. If the issue has been resolved, we would be grateful if you could share the resolution or key insights here to assist others in the community.
In the event that we do not receive a response, we will proceed to close this thread. Should you require any further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum by initiating a new thread. We will be happy to assist you.

Thank you.