Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connecting Microsoft Teams File to Gateway

Hello,    I have connected my Power BI Desktop report to a Teams file. Now I am trying to schedule refreshes via my on-premise gateway. I have tried every authentication method but can not get the ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

Can you try and change the Privacy Level to none and see if that will refresh the file?

If it does then it is possibly multiple files that are being combined which would need the privacy level to be changed.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, 

 

I changed privacy level to None and re-published. Unfortunately I was still unable to connect this file to the gateway. Any other thoughts? 

 

Thanks!

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    How are you connecting to the teams file?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello, 

       

      I connected using "Web". The URL I put in is the link retrieved by doing "Copy Link to Clipboard" pictured below. This is the only way I have been able to connect an excel file stored in Teams to a Power BI report.

       

      Thanks, 

      Stefen

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        Hi there

        If you can make sure you remove the "?web=1" from the end of the link.

        And then it should work, it certainly works for me.