Sep 14 2020 02:43 AM
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
Sep 14 2020 02:53 AM
From Folder connector is for local folders, if this case you need to use From SharePoint Folder connector.
Sep 14 2020 11:59 PM
@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?
Sep 15 2020 01:56 AM
@Sergei Baklan apologies but problem has been resolved after visiting the data source settings (permissions).
THanks.