Forum Discussion
Power Query does not load ANY data into the data model
I just found the problem. The semi-colon in the project folder name was causing the problem. When I removed the semi-colon from the folder name I stopped getting the error.
Thanks for taking the time to respond and pointing me in the right direction.
-Dave J
Thanks for trying it out for me.
I did some more experimentation. If I save the workbook to any other folder on my computer it works fine just like you say. When I save it back to my project folder I get the error message. I guess I could work around this curious behavior its just very strange.
- My file was stored in SharePoint (in premises) and this recommendation worked.
- What does the folder path look like?
Non working folder path:
F:\ShareFile\Personal Folders\Davidj\Plant 1\Projects\038; Highline Excel 2016
Working folder paths:
Every other folder on any drive I've tried so far. Even parent folders of "\\038; Highline Excel 2016" do not give the error.
As I write this it sounds so bizarre that I had to go back and verify this behavior. I open the file from "\\038; Highline Excel 2016" and try to load the query to the data model. As expected I get the invalid connection string error.
Next, I File -> Save As to the "\\Projects" folder and the query loads to the data model just fine. I don't restart Excel it just simply works. Finally, I File -> Save As back to "\\038; Highline Excel 2016" and try to load the query to the data model and I get invalid connection string.