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.
Hi All
My raw data save at share point , i like to know how to use PBI to read the below raw data file :-
Solved! Go to Solution.
Thats not the URL I used, try this
https://isdnholdings.sharepoint.com/sites/TDSGroup
Phil
Proud to be a Super User!
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
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
Proud to be a Super User!
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 :-
May i know what link i should use ?
Paul
Try using the 2nd link, if it doesn't work then try the first one.
Regards,
Manikumar
Proud to be a Super User!
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
Hi All
I found the error , for sharepoint folder access , i need to go to below section enter ID and PW.
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
Proud to be a Super User!
Thats not the URL I used, try this
https://isdnholdings.sharepoint.com/sites/TDSGroup
Phil
Proud to be a Super User!
Hi Phil
I have close PBI file and open again and paste the link you give me , i still get error msg :-
Hi @Paulyeo11
With the file connected you should see its contents in the query editor?
Try closing and restarting PBI Desktop.
Phil
Proud to be a Super User!
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 :-
One way is to use the Sharepoint Folder connector to open https://isdnholdings.sharepoint.com/sites/TDSGroup then locate your file
Phil
Proud to be a Super User!
Hi Phil
I manage to get it connected , but when i try to refresh , i get below error :-
@Paulyeo11 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |