Forum Discussion
Create BI auto refresh with excel data from MS Teams
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.
Is there a resolution or am i copying the link wrongly? Thank you
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
5 Replies
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
- 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.
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
