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
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.
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
- Outstanding!
