SharePoint excel Data set Pulling Old Data when import to power bi service( but work fine asworkboo)

[AIwithBI]

Need Help Please

Power BI Service- Im Impporting  Data from Excel file Located in Sharepoint [Get Data-Files-Sharepoint Team sites-Then url] once  import data to power BI service it shows old Data ( , But source and excel file contain never data )

not only that , once i import the excel file to power bi it also auto generate Dashboard.

if i do the Connect as excel work book not the Import it contain uptodate data and also it refresh same time if do any changes to the sharepoint excel work book.( which is good)

1/  How i can Impoprt data set with newer data to excel file located in sharepoint to power bi service and also wanna refresh the visuals once sharepoint excel file get any updates

Thank You

[AIwithBI]

Hi

Thanks everyone for support.( resolved)

 I didnt realize there was a query connection already set up in excel file in sharepoint. ( so Power Bi was showing old data) Once i refresh the query connection Power bi start refreshing Data , which is really Cool.

( i Completely delete the query connection which setup in excel file located in SharePoint, Bcos power bi Service do a better refresh and connection through Get Data)

Thank you

[v-eqin-msft]

Hi @AIwithBI ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

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.

[lbendlin]

Does it have to be in the service or can you work with Power BI Desktop instead? There you can use the Shareport Folder connector to get to the Excel file.