Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lihobday
Frequent Visitor

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. 

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

1 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

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

View solution in original post

5 REPLIES 5
v-jiascu-msft
Employee
Employee

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

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

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.

Create_BI_auto_refresh_with_excel_data_from_MS_Teams

 

 

Best Regards,

Dale

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

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?

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors