How to schedule a refresh on data sourced from MS Teams

[LisaBrown]

Hi All,

I've created a report in desktop using an Excel Data Source in MS Teams. I've published this on-line to the Premium Service but am unable to schedule a refresh to the data. I'm being asked for my credentials (at which point i enter my Microsoft Username & Password) but continue to get an 'Invalid credentials' message. Has anyone done this successfully? I'd appreciate your feedback on how you did it. Thanks In Advance

[colbertm · Accepted solution]

Excel files in Teams are stored in sharepoint. Access the file from the underlying SharePoint site and then use oAuth2 authetication to refresh in the service.

[aj1973 · Accepted solution]

Hi @LisaBrown 

In Power BI Desktop, have you used Sharepoint Folder Connector or WEB connector to build your report?

Many fall into the mistake when connecting to a folder in Teams, Sharepoint Folder connector must be used.

[colbertm · Accepted solution]

Excel files in Teams are stored in sharepoint. Access the file from the underlying SharePoint site and then use oAuth2 authetication to refresh in the service.