Forum Discussion

Milejdi8's avatar
Milejdi8
Frequent Visitor
2 years ago
Solved

Excel does not "see" Dataset refresh

Hello,  We are using Office 365 for Enterprise.  From Excel, we go to Data / Get Data / from Power Platform / From Powerbi, and we select dataset that we want to use.    However, for some dataset...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Milejdi8 ,

     

    Latest response:

     

    -- The initial list of senmantic models that you see is based on the initial index. However, this index does not contain the latest metadata for the semantic model itself.  It may take up to 24 hours for the index to be refreshed.  This behavior is by design. 
    This is a harmless process. As long as the requested semantic model remains linked to the same location, the latest contents of the semantic model will be pulled from PowerBI and made available in Excel.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Milejdi8 ,

 

update:
The issue has been reported to the product group and engineers are working to investigate. I'll update below with any news.

-------------------------------------------------------------

I have reproduced such behavior.
I manually refreshed the semantic model on 2024-07-29, but it still shows the refresh time of 2024-07-28 in Excel. Upon further inspection I found that the dataset actually contains the latest data (2024-07-29) .

Excel connects to the PowerBI semantic model through Live-Connection mode at this point, and the query results should be the latest data in the semantic model.
Could you please try inserting a pivot table in Excel to check if it contains the latest data (either by checking the number of records in the fact table or the latest records)?

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum