Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power BI Semantic not adding new rows from excel auto refresh

Hi,

 

I have a Task Scheduler set up for auto refresh data for Excel connected to SQL Server. That is working just fine. However, I notice that the Power BI semantic model(or the report) is not updating the new rows of date despite completed message that refresh was done.

 

If I manually refresh the semantic model, it will add the new rows.

 

Did I miss a step somewhere for the auto refresh to add new rows of data into the semantic model or ?

 

Thanks 🙂

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    ahhhh.....ok I just cleared out the browser cache - next auto refresh will be an hour and half away and I will check again. 

8 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    1 year ago

    Hi Anonymous 

     

    Can you confirm that you did use a CTRL + F5 to remove the cache?

     

    Also did you change the reset to default to reset any filters?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi GilbertQ!

       

      Can you confirm that you did use a CTRL + F5 to remove the cache? I was not aware of this so I looked it up. WOW! HAD NO IDEA. So I cleared the cache just now. 

       

      Also did you change the reset to default to reset any filters? What do you mean by that?

      • GilbertQ's avatar
        GilbertQ
        Super User
        1 year ago

        That is for the browser cache.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Ok I reset everything. Let's see the next auto refresh looks like tomorrow morning and I will let you know then.

       

      Thank you!

      • v-nmadadi-msft's avatar
        v-nmadadi-msft
        Community Support
        1 year ago

        Hi Anonymous,
        Thanks for reaching out to the Microsoft fabric community forum.

        Have you experienced the issue again or has GilbertQ's suggestion helped mitigate the issue.
        Please let us know if you have any further queries

        Thanks and regards