Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error

Download Files:

Start File and Finished File:

In Power Query see how to use deal with the Refresh Error Message:
We couldn’t refresh the connection. Here is the error message we got:
[DataSource.NotFound] File or Folder: We couldn’t find the folder.

[krismaly]

I enjoyed watching this video and recommend others to watch.

Host seem to be extremely knowledgeable and expert in Excel

He has designed the course I feel extremely good. Worth paying to buy the course.

With this sample video I learned a bunch.


Thanks for educating the community and appreciate your volunteership.

Keep posting some more videos.

Thanks a bunch

[NHHT]

The video was awesome, the explanation was very easy to follow. thank you. I have a question. what is best? combining Xls files or Xlsm or CSVs? Size wise and what is easier to do (steps wise). Thank you so much!

[ADIVALIUS]

Hi, You are the best. I can see the "Acrobat" layer. What is the trick number video?

[najumehra]

Thanks this is great, but wondering if you can help a bit further, my initial source i have delted my first row as it is just title, but when i update my source it shows error. I was thinking powerquery does all the actions as per your initial query

[DrCheeseMD]

hey there, is there a workaround for refreshing a power query when the source file is open and in use? i need real time updates from employees workbooks and its the last big problem im having. thanks in advance!

[Hasret]

Hi, thanks for your amazing exel tutorials. Can you maybe also show how we can fix problem, when a worksheet is open, the external excel tables can not be update/ refreshing. Thanks!

[entertainmentgalaxy]

Thanks alot this is what i was looking for. I m wondering will it work if i rename my file?

[sandeepr]

In your video high line excel 2016 class 03 the get transform from table happens so swiftly but I am getting the below error, please help me ...

[kittydoes]

Hello. How about this error: Download did not complete after the refresh.?

[TheNovember]

Dear Mike
Normally this option works but today i encounterd a problem later on in aplied steps it refrenced to the old data source, I looked in the code I could (which I'm not good in) I could not make out why it was, then i tried to modify the steps using on home tab data source settings, then it worked. I do not know why this step works and the other doesn't.
I preciated very much your please carry on
Best regards Eric

[spvmlfo]

hi could you help me with this error message :
"we couldnt get data from the data model. heres the error message we got

the attributerelationship with attributeID doesnt exist in the collection"

[SuperCoolTeddy]

1 question : how to change the table data source in query in same workbook to another table? As when I try editing the table name in source, it's throwing errors. exceptions related to datawarehouse. thanks

[edsilnazareno]

I need help. I used "connection only" in my pivot, however, I lost the connection between the pivot and power query, when I EDIT the data inside the connection only.

[BornTrade]

Sir, how to press ok by micro of this popup

[sandeepr]

Hi Miguel, please help me with this error- initialization of data source failed.
Check the database server or contact your data base administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the data base....Please please help

[Souviri]

Hi, I have an issue with my source tab in 'Applied steps" it does not have the settings button. And I cannot refresh my power query. What is it that I am doing wrong?

[BriceSone-vvmi]

How does one resolve the problem of Connections only under the Queries and Connections display output? Data doesn't load.

[shrirajdeshpande]

Hi Mike,
Plz help...I am getting error - Download failed after clicking on Load to "PivotTable Report" but the same data is getting loaded when clicked on load to "Only Create Connection"....