Forum Discussion

NoviceKB's avatar
NoviceKB
Brass Contributor
Sep 14, 2020

Error loading to Data Model

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 sta...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 14, 2020

NoviceKB 

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

  • NoviceKB's avatar
    NoviceKB
    Brass Contributor
    Sep 15, 2020

    SergeiBaklan 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?

    • NoviceKB's avatar
      NoviceKB
      Brass Contributor
      Sep 15, 2020

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

       

      THanks.

Resources