Forum Discussion
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 ...
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
Super User
Super UserHi 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.
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.
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,
- GilbertQWhat happens if you open the file directly from SharePoint Online and not via teams?
And then get the link from SharePoint online?I am unable to connect to the datasource that way. In order to connect successfully I have to get the link as shown above.