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 have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Just following up to confirm if you have raised the support ticket. If so, please share any feedback or solutions received. Kindly consider marking the solution as accepted to assist the community.

Thank you.