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

Anonymous Thats not the URL I used, try thishttps://isdnholdings.sharepoint.com/sites/TDSGroupPhil

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

13 Replies

PhilipTreacy
Super User
5 years ago
Anonymous
Thats not the URL I used, try this
https://isdnholdings.sharepoint.com/sites/TDSGroup
Phil
- Anonymous
  Not applicable
  5 years ago
  Hi Phil
  
  I have close PBI file and open again and paste the link you give me , i still get error msg :-
amitchandak
Super User
5 years ago
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
PhilipTreacy
Super User
5 years ago
Anonymous
One way is to use the Sharepoint Folder connector to open https://isdnholdings.sharepoint.com/sites/TDSGroup then locate your file
Phil
- Anonymous
  Not applicable
  5 years ago
  Hi Phil
  
  I manage to get it connected , but when i try to refresh , i get below error :-
PhilipTreacy
Super User
5 years ago
Hi Anonymous
With the file connected you should see its contents in the query editor?
Try closing and restarting PBI Desktop.
Phil
- Anonymous
  Not applicable
  5 years ago
  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 :-
manikumar34
Solution Sage
5 years ago
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
  Not applicable
  5 years ago
  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
  - manikumar34
    Solution Sage
    5 years ago
    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
- Anonymous
  Not applicable
  5 years ago
  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=d423f8c3%2D092c%2D45c9%2Dbfa1%2Dbb92d31ee0aa&id=%2Fsites%2FTDSGroup%2FShared%20Documents%2FPBI%20FOLDER%2FSALES%20INVOICE%20TDS
  
  May i know what link i should use ?
  
  Paul
  - manikumar34
    Solution Sage
    5 years ago
    Try using the 2nd link, if it doesn't work then try the first one.
    
    Regards,
    Manikumar