Power Query not pulling most recent data

[jennic]

I'm pulling data from SharePoint libraries using the URL in Power Query. I noticed some of my files weren't named correctly in my first attempt to Transform Data. I closed the Query and didn't save changes. Then, I updated the files names to make it easier to pull in the future. When I went back to start a new Query, the files I changed in SharePoint were still under the old names in the Transform Data window. I tried refreshing the SharePoint site and libraries, and I removed the Recent Sources in the Data tab. I need to be able to perform the Query regularly in the future and get correct data. How can I get it to pull the updated data from the libraries?

[PabloVallejo12]

Hello 

Maybe u are getting the URL from desktop app?(local path)

You should get this URL from Sharepoint 

I hope this can help u 

[V-yubandi-msft]

Hi @jennic ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[V-yubandi-msft]

Hi @jennic ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

[V-yubandi-msft]

Hi @jennic ,

Thank you for reaching out to the Microsoft Fabric Community. In addition to @lbendlin  response, this behavior is likely caused by Power Query caching old file metadata even though you've renamed the files in SharePoint, the Query Editor may still be displaying the old names. 

Thank you for your response @lbendlin .

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly

[jennic · Accepted solution]

I'm not sure what happened, but suddenly the file names were correct. It seems like what you're suggesting is correct, but I don't know how it was fixed or what to do in the future if this happens again. 

[V-yubandi-msft]

Thank you for your update. If you believe the solution is correct , kindly mark it as the accepted solution. it helps other community members find it easily.

If you encounter a similar error in the future, you can refer to the steps provided to resolve it quickly.

Regards,

Yugandhar.

[lbendlin]

For the development cycle you use the "Refresh Preview"  button.  Once published this caching issue will go away.