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

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.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi GilbertQ , 

 

Yes I am removing the "?web=1" from the end of the link. This enables me to connect to and refresh the file in Desktop however I am unable to connect this data source to my Gateway for Scheduled Refresh.

 

Any other thoughts?

 

Thanks,

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    What happens if you open the file directly from SharePoint Online and not via teams?

    And then get the link from SharePoint online?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am unable to connect to the datasource that way. In order to connect successfully I have to get the link as shown above.

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

        I am sure that you can connect to the file, you just have to find the location of the files.

        If you had to remove the file name and put that into a browser I am sure that it will take you to the location where the files are stored?