Forum Discussion

Bluebell's avatar
Bluebell
New Member
6 years ago
Solved

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   Fur...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Bluebell ,

     

    You can get the Excel link in Teams follow this article: 

     
     

     

    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),

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Bluebell ,

 

You can get the Excel link in Teams follow this article: 

 
 

 

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),