PowerBI Dataset based on .xlsm wont refresh on new entries

[dsx2]

Hi all,

Trying to create a report based on an xlsm dataset stored in Onedrive for business.

The dataset is formatted in Power Pivot and loads correctly. 

However, on adding new lines to the table, it is not being refreshed by PowerBI. I have to open the excel file -> go into PowerPivot -> Refresh from there. The new lines that are added are automated so this is a bit of a inconvienence. 

Opening the file in Excel for Web and refreshing also causes the same issue, so I believe the issue lies with PowerPivot rather than Power BI?

I am unsure what I am missing, as the documentation says it should work?

Any help is appreciated.

[Testing1014]

I have the same problem. My xlsm file in shared in a sharepoint folder. Power BI dekstop is able to refresh the data and show the new entries. Power Bi service is also able to refresh the data in few minutes but it doesn't show the new entries.

[Anonymous · Accepted solution]

Hi @dsx2 

1.Your dataset is stored on Onedrive, so when you import the data from onedrive, it will execute Onedrive-refresh. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.it can take Power BI up to 60 minutes to refresh a dataset. You can refer to the following link to know about Onedrive refresh.

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#onedrive-refresh

2.Please check that you have selected  Keep me signed in when you sign into your Microsoft account,  Power BI can then synchronize any updates with datasets in Power BI.

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-csv-file-onedrive#when-things-go-wro...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dsx2]

Forgot to mention, there is no external data sources.