how to get data updated from excel

[Anonymous]

Hi,

i have created excel data source and build report based on that excel and publish to server. 

That excel sheet keep adding new datainto it.

Please guide me how my publish reports gets updated data from excel sheet. 

thx

[Eric_Zhang · Accepted solution]

@Anonymous

You can use gateway to do he refresh, check more details in this link Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online.

[ElliotP]

Evening,

1.Go to the powerbi website where you can see your reports and dashboards on the web.

2. Settings. The little gear in the top right hand corner from the dropdown menu it gives you.

3. Dataset. Pick your related dataset.

4. Change Scheduled Refresh Settings.

To change the scheduled refresh for an excel file on your local machine you'll need pro (you can try for free as well).