Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to copy link from sharepoint to PBI folder ?

Hi All

My raw data now move to share point. 

Paulyeo11_0-1605084220125.png

I need to edit the path , so that when i refresh , it will point to share point folder.

Paulyeo11_1-1605084321887.png

 

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

 

1 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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

11 REPLIES 11
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi sheng

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

PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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

amitchandak
Super User
Super User

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

amitchandak
Super User
Super User

@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
Not applicable

@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
Impactful Individual
Impactful Individual

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.