Forum Discussion
How to copy link from sharepoint to PBI folder ?
Hi Anonymous,
Folder connector only works with the local folders, it not work when you try to use it to get data from the network driver such as onedrive/SharePoint. (I think folder connector may require high operations permissions, and specific system libraries so that it not support with 'network' drivers)
You can also check the following blog about how to get data from SharePoint/onedrive folder files if they meet your requirement:
Connecting to Files in SharePoint & OneDrive with Power BI / Power Query
Regards,
Xiaoxin Sheng
Super UserHi Anonymous
You're actually loading the files from a local PC hard drive
Source = Csv.Document(File.Contents("C:\Users\pauly\OneDrive - ISDN Holdings Limited\PBI FOLDER\SI_TS_N.csv"),[Delimiter=",", Columns=25, Encoding=1252, QuoteStyle=QuoteStyle.None]),
You need to change the query so it loads from Sharepoint so you end up with something like this as the first step
Source = SharePoint.Files("https://isdnholdings.sharepoint.com/sites/TDSGroup/", [ApiVersion = 15]),
Phil
Hi Phil
When i try to load on GL file from one drive :-
let
Source = Folder.Files("C:\Users\pauly\OneDrive - ISDN Holdings Limited\PBI FOLDER\GL_TDS"),
#"C:\Users\pauly\OneDrive - ISDN Holdings Limited\PBI FOLDER\GL_TDS\_GL_TS csv" = Source{[#"Folder Path"="C:\Users\pauly\OneDrive - ISDN Holdings Limited\PBI FOLDER\GL_TDS\",Name="GL_TS.csv"]}[Content],
#"Imported CSV" = Csv.Document(#"C:\Users\pauly\OneDrive - ISDN Holdings Limited\PBI FOLDER\GL_TDS\_GL_TS csv",[Delimiter=",", Columns=11, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"GL Code", Int64.Type}, {"GL Description", type text}, {"Type", type text}, {"Month", Int64.Type}, {"Year", Int64.Type}, {"Posting Date", type date}, {"AccCur", type text}, {"AccConvRate", Int64.Type}, {"C/D", type number}, {"CurrencyValue", Int64.Type}, {"Reporting Code", Int64.Type}})
in
#"Changed Type"Now if i can load data using sharepoint folder to PBI , then i can copy the path and paste to above , but too bad i still unable to load using sharepoint folder connector.
Paul
Hi Anonymous,
Folder connector only works with the local folders, it not work when you try to use it to get data from the network driver such as onedrive/SharePoint. (I think folder connector may require high operations permissions, and specific system libraries so that it not support with 'network' drivers)
You can also check the following blog about how to get data from SharePoint/onedrive folder files if they meet your requirement:
Connecting to Files in SharePoint & OneDrive with Power BI / Power Query
Regards,
Xiaoxin Sheng
Hi sheng
Thank you for share the link. It help me a lot.