automated refresh of data from teams folder

[Anonymous]

i have report locally now i want to connct data set from teams and it will be automated referesh any idea .

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I'm sorry that I misunderstood your question before.😞

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 

Using a file in Microsoft teams as a data source 

Trying to connect to data in Teams/Sharepoint - help please 

Use Excel file from Microsoft Teams as data Source 

How to connect files from MS Teams to Power BI 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft]

Hi, @Anonymous 

From PowerBI Desktop select Get Data from Folder or Excel.
If there is only one Excel file you can get the data from Excel, if there is one or more files in the folder you can get the data from the folder. Then transform the data in PowerQuery editor.

You can then refresh manually from the PowerBI desktop or publish the report to the service and configure a scheduled refresh in the service.

See links below for more information:

Combine files (binaries) in Power BI Desktop 

https://powerbi.tips/2016/06/loading-data-from-folder/

Power BI - Connecting files in a folder 

Data refresh in Power BI 

Configure scheduled refresh 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.