Forum Discussion

dave_j's avatar
dave_j
Copper Contributor
Dec 03, 2018
Solved

Power Query does not load ANY data into the data model

I can't load any data from power query to the data model.  I'm running 32-bit Excel 365 (v16.0.11029.20045) on Windows 10   Every time I try to load data from Power Query to the Data Model I receiv...
BI & Data Analysis
excel
office 365
  • dave_j's avatar
    dave_j
    Dec 05, 2018

    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

     

     

dave_j's avatar
dave_j
Copper Contributor
Dec 04, 2018

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.

 

 

JPH19's avatar
JPH19
Copper Contributor
Mar 11, 2019
My file was stored in SharePoint (in premises) and this recommendation worked.

Resources