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
Present I'm using source as Excel file that are avaiable in my Remote Machine - and using those as source to the Power BI desktop.
Now the Management wants to uses the Teams folder ( wehre the folder is created in Teams and will going to kept the excel files in the Teams folder), Now i want to use that Teams folder as source to my Power BI.
My Teams access and my Power BI is avaible in the same Remote machine. How to use that ?
1.) Now the intention is we already developed the reports, now we want to change the source to the Teams folder with out disturbing the development reports.
2.) How to use teams folders as source to Power BI, I tried to put the copied teams url to the source as "Sharepoint folder" but its throwing error.
Thanks,
Solved! Go to Solution.
Hi, @ramshoney1225
If you want to connect to excel file from MS Teams with Power BI Desktop,please refer to this official documnet to get the url of excel and try "web connector".
desktop-use-onedrive-business-links
You need to remove ?web=1 string at the end of the link as mentioned in the article.
If you want to connect to folder from MS Teams, please try "sharepoint connector".
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/237546
After connecting you need do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
You can also check if these related documents could help.
Link-MS-Team-excel-spreadsheet-link-to
Connect-Power-Bi-to-a-Microsoft-Teams-SharePoint-site
connect-files-from-teams-to-power-bi.html
Best Regards,
Community Support Team _ Eason
You can also checkout this video which will tell you how to do it - https://youtu.be/MC6TJMaiCRo
hi,
You can check the link for the sharepoint folder of teams
click on open in sharepoint and you will get the share point site from there you can connect to sharepoint folder from power BI.
Thanks @malleshG for quick response.
Ya i tried that in Remote machine, I copied it the url but still throwing an error. Then Input URL is invalid.
Hi,
Do not copy whole URL you copy only till site name(Team Name) exmample.
https://Test121.sharepoint.com/sites/Teamsname
Hi, @ramshoney1225
If you want to connect to excel file from MS Teams with Power BI Desktop,please refer to this official documnet to get the url of excel and try "web connector".
desktop-use-onedrive-business-links
You need to remove ?web=1 string at the end of the link as mentioned in the article.
If you want to connect to folder from MS Teams, please try "sharepoint connector".
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/237546
After connecting you need do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
You can also check if these related documents could help.
Link-MS-Team-excel-spreadsheet-link-to
Connect-Power-Bi-to-a-Microsoft-Teams-SharePoint-site
connect-files-from-teams-to-power-bi.html
Best Regards,
Community Support Team _ Eason
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |