Forum Discussion
Can power bi refresh excel sheet dynamically once the user has updated the excel sheet in Sharepoint
Hi,
we have an excel sheet at sharepoint. The business user has excess to this excel sheet and updates it manually. The powerbi simply shoes all the files in this excel sheet. How can we refresh the excel sheet data set dynamically once the user has updated the sheet so that the updated records are shown on the report.
Thanks
Hi Anonymous
If you connect to sharepoint online,
Please refer to:
Refresh a dataset stored on OneDrive or SharePoint Online
Integrating SharePoint Online and Power BI
If the data source is on-premise, you need to download a on-premise gateway to perform refresh.
How to publish SharePoint data to Power BI using the enterprise gateway
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-juanli-msftCommunity Support
Hi Anonymous
If you connect to sharepoint online,
Please refer to:
Refresh a dataset stored on OneDrive or SharePoint Online
Integrating SharePoint Online and Power BI
If the data source is on-premise, you need to download a on-premise gateway to perform refresh.
How to publish SharePoint data to Power BI using the enterprise gateway
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.