Forum Discussion
SharePoint excel Data set Pulling Old Data when import to power bi service( but work fine asworkboo)
- Anonymous5 years ago
Hi AIwithBI ,
According to my test, manual refresh is not effective for reports generated by excel imported from SharePoint. Just as the introduction shown below said :
I also found the basis from the official document , It can take Power BI up to 60 minutes to refresh a dataset, even once the sync has completed on your local machine and after you've used Refresh now in the Power BI service.
So if you want the newest data imported from excel in ShartPoint, you could adopt lbendlin 's suggestion——
1. Get data from SharePoint Folder in Power BI Desktop, then publish the report to service.
2. You could click "Refresh Now" option manually or enable Scheduled refresh option after inputing user credentials.
3. Sometimes due to network reasons or the like will cause the refresh delay, you could use the Refresh button in report page of browser or reopen the report to get data quickly.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi AIwithBI ,
According to my test, manual refresh is not effective for reports generated by excel imported from SharePoint. Just as the introduction shown below said :
I also found the basis from the official document , It can take Power BI up to 60 minutes to refresh a dataset, even once the sync has completed on your local machine and after you've used Refresh now in the Power BI service.
So if you want the newest data imported from excel in ShartPoint, you could adopt lbendlin 's suggestion——
1. Get data from SharePoint Folder in Power BI Desktop, then publish the report to service.
2. You could click "Refresh Now" option manually or enable Scheduled refresh option after inputing user credentials.
3. Sometimes due to network reasons or the like will cause the refresh delay, you could use the Refresh button in report page of browser or reopen the report to get data quickly.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.