Is it possible to automatically refresh the data source in MS Teams?

[Anonymous]

Hi there,

I am getting the same type of excel file weekly (same amout of columns, same tables etc) but with a different name.

My goal is it to automate the refresh of the data source within our MS Teams environment.

Is this even possible?

Do you have any suggestions for me?

Thanks in advance!

[v-angzheng-msft]

Hi, @Anonymous 

Here is some reference information for setting up dynamic paths:

https://community.powerbi.com/t5/Desktop/Dynamic-folder-location/m-p/573860

https://www.excelguru.ca/blog/2017/01/04/make-the-sample-binary-file-path-dynamic/

https://www.goodly.co.in/dynamic-file-path-power-query/

https://community.powerbi.com/t5/Desktop/Dynamically-change-data-source-relative-source-paths/m-p/378219

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.

[negi007]

@Anonymous  I think files which are saved in MS-team are normally saved on the sharepoint folders. In your case, if your new file has new data and you wish to have it also in your powerbi dashbaord. You can try using sharepointfolder option to see if it works for you. 

Below is the link that you can guide in the right direction.

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/#:~:text=Open%20up%20PowerBI%20Desktop%20and,and%20click%20Connect%20to%20continue.&text=Upon%20clicking%20connect%20you%20will,site%20that%20we%20identified%20above.