Forum Discussion
Refresh button on the published report - does not refresh data
Hi,
If you used “Web” or “SharePoint Folder” to connect to a file stored in OneDrive/SharePoint Online using the proper link, refresh will work, but the gateway may still be required depending on the configuration!
Best Practice (No Gateway Needed):
To connect to an Excel file on SharePoint:
- Go to SharePoint Online > Locate your Excel file
- Click the three dots (...) > Open in browser
- Copy the URL up to the .xlsx (it will look like: https://tenant.sharepoint.com/sites/YourSite/Shared Documents/filename.xlsx)
- In Power BI Desktop:
- Use the Web connector
- Paste the full link
- After publishing to Power BI Service:
- Go to Dataset > Settings > Data source credentials
- Set it to OAuth2 > Organizational account and sign in
Hi,
If you used “Web” or “SharePoint Folder” to connect to a file stored in OneDrive/SharePoint Online using the proper link, refresh will work, but the gateway may still be required depending on the configuration!
Best Practice (No Gateway Needed):
To connect to an Excel file on SharePoint:
- Go to SharePoint Online > Locate your Excel file
- Click the three dots (...) > Open in browser
- Copy the URL up to the .xlsx (it will look like: https://tenant.sharepoint.com/sites/YourSite/Shared Documents/filename.xlsx)
- In Power BI Desktop:
- Use the Web connector
- Paste the full link
- After publishing to Power BI Service:
- Go to Dataset > Settings > Data source credentials
- Set it to OAuth2 > Organizational account and sign in
Hello some_analyst
You can use Power Automate to provide on demand refresh button
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
