Error loading to Data Model

%3CLINGO-SUB%20id%3D%22lingo-sub-1663519%22%20slang%3D%22en-US%22%3EError%20loading%20to%20Data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663519%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20finally%20making%20my%20way%20into%20Power%20Query%20after%20a%20short%20course%20on%20it%20as%20I%20am%20constantly%20creating%20all%20kinds%20of%20excel%20reports%20and%20dashboards.%20I%20have%20big%20monthly%20payroll%20files%20%2B%20other%20staff%20related%20excel%20reports%20which%20I%20must%20convert%20into%20a%20dashboard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%20and%20as%20I%20tried%20to%20load%20my%20query%20into%20a%20datamodel(as%20a%20connection)%2C%20I%20got%20the%20attached%20error%20and%20I%20am%20clueless%20where%20to%20start%20looking%20for%20a%20solution%20to%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20monthly%20files%20are%20located%20in%20a%20folder%20on%20my%20Onedrive%20with%20the%20following%20location%2Fpath%3A%3C%2FP%3E%3CP%3EC%3A%5CUsers%5C%3CEM%3Emyname%3C%2FEM%3E%5COneDrive%20-%20Vivo%20Global%5CReports%202020%5CPower%20Query%20Dashboard%5C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20because%20this%20folder%20is%20on%20Onedrive%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENoviceKB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1663519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663565%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20loading%20to%20Data%20Model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677879%22%20target%3D%22_blank%22%3E%40NoviceKB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20Folder%20connector%20is%20for%20local%20folders%2C%20if%20this%20case%20you%20need%20to%20use%20From%20SharePoint%20Folder%20connector.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi Team,

 

I am finally making my way into Power Query after a short course on it as I am constantly creating all kinds of excel reports and dashboards. I have big monthly payroll files + other staff related excel reports which I must convert into a dashboard.

 

I am using Office 365 and as I tried to load my query into a datamodel(as a connection), I got the attached error and I am clueless where to start looking for a solution to this.

 

My monthly files are located in a folder on my Onedrive with the following location/path:

C:\Users\myname\OneDrive - Vivo Global\Reports 2020\Power Query Dashboard\

 

Is it because this folder is on Onedrive?

 

Thanks.

 

NoviceKB

 

 

 

3 Replies
Highlighted

@NoviceKB 

From Folder connector is for local folders, if this case you need to use From SharePoint Folder connector.

Highlighted

@Sergei Baklan thanks for the feedback.

 

I just tried the sharepoint folder but getting this error below:

 

Details: "Access to the resource is forbidden."

 

Any idea how I can overcome that?

Highlighted

@Sergei Baklan apologies but problem has been resolved after visiting the data source settings (permissions).

 

THanks.