How to get PBI read raw data from share point folder ?

[Anonymous]

Hi All

My raw data save at share point , i like to know how to use PBI to read the below raw data file :-

[manikumar34]

@Anonymous 

Check the below examples to connect with your sharepoint folder to local folder. 

https://radacad.com/change-excel-source-in-power-bi-to-onedrive-for-business-no-gateway-needed

https://community.powerbi.com/t5/Power-Query/Change-Source-from-Folder-to-SharePoint-Folder/m-p/694725

you are using wrong link while taking the data

Use https://isdnholdings.sharepoint.com/sites/TDSGroup instead  https://isdnholdings.sharepoint.com/:f:/s/TDSGroup/

Regards, 

Manikumar

[Anonymous]

Hi Mani

When i click on below link :-

https://isdnholdings.sharepoint.com/sites/TDSGroup

it will lead me to below page :-

But my raw data save at below folder :-

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

May i know what link i should use ?

Paul

[manikumar34]

Try using the 2nd link, if it doesn't work then try the first one. 

Regards, 

Manikumar

[Anonymous]

Hi Mani

Thank for share the 2 links , after watching the video , now i think the issue is , the share point folder path is share from my HQ , and i am unable to access thru PBI. 

Paul

[Anonymous]

Hi All

I found the error , for sharepoint folder access , i need to go to below section enter ID and  PW.

[manikumar34]

@Anonymous , 

Check with the sharepoint link and to replace local folder data to sharepint folder follow the steps in raadacard example. 

You have to replace the source settungs in M query, not in data source settings. 

Regards, 

Manikumar

[PhilipTreacy · Accepted solution]

@Anonymous 

Thats not the URL I used, try this

https://isdnholdings.sharepoint.com/sites/TDSGroup

Phil

[Anonymous]

Hi Phil

I have close PBI file and open again and paste the link you give me , i still get error msg :-

[PhilipTreacy]

Hi @Anonymous 

With the file connected you should see its contents in the query editor?

Try closing and restarting PBI Desktop.

Phil

[Anonymous]

Hi Phil

https://isdnholdings.sharepoint.com/:f:/s/TDSGroup/

When i paste above link to PBI sharepoint folder  , the ok button turn to yellow .

But I still  get this error msg :-

[PhilipTreacy]

@Anonymous 

One way is to use the Sharepoint Folder connector to open https://isdnholdings.sharepoint.com/sites/TDSGroup then locate your file

Phil

[Anonymous]

Hi Phil

I manage to get it connected , but when i try to refresh , i get below error :-

[amitchandak]

@Anonymous , refer if these two can help

https://community.powerbi.com/t5/Desktop/How-to-load-csv-file-from-Sharepoint-folder/td-p/85066

https://community.powerbi.com/t5/Desktop/add-sharepoint-csv-files-to-query/td-p/918134