Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All
My raw data now move to share point.
I need to edit the path , so that when i refresh , it will point to share point folder.
My question is i have copy the link from share point :-
paste the above link to PBI folder link , it get error.
Paul Yeo
Solved! Go to Solution.
Hi @Paulyeo11,
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 @Paulyeo11
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
Proud to be a Super User!
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 @Paulyeo11,
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.
hi @Paulyeo11
If you've started by loading a file/files using the Folder connector and have then moved these file(s) to Sharepoint, you need to use a different connector.
You'll need to recreate the steps from the local folder load in the Sharepoint loading query.
Start a new query and load the folder from Sharepoint. Do whatever you need to do to locate the file(s). The idea here is to get to the same point in Sharepoint as you did in the local Foler load query.
Copy the steps in the Sharepoint loading query to the 'original' query you used to load from folder.
Its a bit hard to explain especially without having your query code in front of me - can you supply it?
FYI - writing queries and then moving the files to another location that requires a different connector will get you in trouble if you don't know how to make the necessary changes. Best to do your development in the final location if you can.
Regards
Phil
Proud to be a Super User!
Hi Phil
Below is my PBI file which work fine , but it load from one drive folder :-
https://www.dropbox.com/s/6p92kss27fiminr/SI_TDS_V75%20only%20adl.pbix?dl=0
Now i need to move all raw data file to sharepoint , i stuck at how to change.
Paul
@Paulyeo11 , if it is an excel/csv, copy the link after opening it in excel. The process given in link
Hi Amit
Thank you for your sharing.
Now I am import CSV file using folder from my note book one drive.
I need to change the path to share point path.
I try copy the path from share point paste to PBI
I Get error.
@Paulyeo11 , there is a small change in URL, the same is true for onedrive/SharePoint -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
@Paulyeo11 Try this way-
Go to power query editor.
Select the table for which the path has been changed.
In the right side you would see applied steps section.
Duble click on source and change the path there.
Hi Sir
Your advise on :- Select the table for which the path has been changed.
Do you ref to sharepoint link which i copy from :-
Paul
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |