Create BI auto refresh with excel data from MS Teams

[Lihobday]

How can we connect data from PowerBI online to a MS teams website. Sharepoint is located within a company secure enviroment.

I would copy the link from excel online in the http bar and add into "Enter Site in URL to connect to" but will get the error "The URL Is not valid or you do not have permission to the site"

This was the link i use. Sample ONLY link. 

https://microsoft.sharepoint.com/teams/TESTONLY/_layouts/15/doc.aspx?sourcedoc=%7B7db899fd-c9f6-47f8...

Is there a resolution or am i copying the link wrongly? Thank you

[v-jiascu-msft]

Hi @Lihobday,

Did you mean you want to connect to an online Excel located in Sharepoint? Please refer to this documentation. You need to copy the link from the Excel.

Best Regards,

Dale

[Lihobday]

Thanks. Perhaps i should clarify. I actually know how to connect it already using O365 or sharepoint in desktop version. But from the power BI web version, how do i connect the excel data from sharepoint to the web version? Reason is because i want to have the data refreshed in every instant where there is a change or update in raw data. I understand desktop version has to be refreshed manually and not automatically.

[v-jiascu-msft]

Hi @Lihobday,

1. You can publish the Desktop file to the Service.

2. You can try Get data -> File -> Sharepoint Team sites.

Best Regards,

Dale

[Lihobday]

Thanks. I know how to do that but what should the link be? I seem to get an error msg when i copy the link over via teams or MS Sharepoint. Should i be removing some text from the http links?

[v-jiascu-msft · Accepted solution]

Hi @Lihobday,

You are right. Taking your link as an example, it should be like this: https://microsoft.sharepoint.com/teams/TESTONLY

Best Regards,

Dale