How to copy link from sharepoint to PBI folder ?

[Paulyeo11]

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 :-

https://isdnholdings.sharepoint.com/sites/TDSGroup/Shared%20Documents/Forms/AllItems.aspx?viewid=d42...

paste the above link to PBI folder link , it get error.

Paul Yeo

[PhilipTreacy]

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

[Paulyeo11]

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

[v-shex-msft · Accepted 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

[Paulyeo11]

Hi sheng

Thank you for share the link. It help me a lot.

[PhilipTreacy]

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

[Paulyeo11]

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

[amitchandak]

@Paulyeo11 , if it is an excel/csv, copy the link after opening it in excel. The process given in link

[Paulyeo11]

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.

[amitchandak]

@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

[Anonymous]

@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.

[Paulyeo11]

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 :-

https://isdnholdings.sharepoint.com/sites/TDSGroup/Shared%20Documents/Forms/AllItems.aspx?viewid=d42...

Paul