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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bluebell
New Member

Connecting to a private teams group

I am trying to link various excel files that are all located on private team groups and getting various errors

I trying using connect excel files and obtained the access is forbidden message

 

Further research suggesting using link via a web page and then Sharepoint folder which i have also tried

 

Connecting via a sharepoint page and via a web page gives another message

The service returned an invalid token,  Please contact your IT adminstator if this issue persists.  x-ms-request-id

The process i am following as detailed below

For both sharepoint folder and web page,  i open teams and then opened the sharepoint site and copied the link so reads https://companyname.sharepoint.com/teams/sitename

I then click Ok

I then get the sign in window which if i connect via a sharepoint folder does not give me a organisation account, but i cannot sign in and I get the error message above.

 

Firstly, which method is the best method to use or should i be using another route to connect?

Secondly, if one of these methods is correct is this a permissions issue?

Any other hints and tips greatly appreciated

Many thanks

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @Bluebell ,

 

You can get the Excel link in Teams follow this article

op.PNGop2.PNG

 
 

 

Now you get the link, please remove ?web=1 string at the end of the link as mentioned in the article. 

 

Open the original report in Power BI desktop, go to Query Editor-> Advanced Editor, modify the source step with below: 

 

Source = Excel.Workbook(Web.Contents("<URL you got from above steps>"), null, true),

 

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

View solution in original post

1 REPLY 1
v-frfei-msft
Community Support
Community Support

Hi @Bluebell ,

 

You can get the Excel link in Teams follow this article

op.PNGop2.PNG

 
 

 

Now you get the link, please remove ?web=1 string at the end of the link as mentioned in the article. 

 

Open the original report in Power BI desktop, go to Query Editor-> Advanced Editor, modify the source step with below: 

 

Source = Excel.Workbook(Web.Contents("<URL you got from above steps>"), null, true),

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors