Connecting Microsoft Teams File to Gateway

[Anonymous]

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 data source to connect.

Please see below the gateway error I am getting (Top) and the authentication I am using to connect to the Teams file in desktop (Bottom).

Thank you, 

[GilbertQ]

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]

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]

Hi there

How are you connecting to the teams file?

[Anonymous]

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

[v-lid-msft]

Hi @Anonymous ,

Could you please try to use Realtive path in web.contents function, such as change following:

Web.Contents("https://XXX.sharepoint.com/SiteXXX/2020.xls")

to following:

Web.Contents("https://XXX.sharepoint.com/",[RelativePath="SiteXXX/2020.xls"])

or

Web.Contents("https://XXX.sharepoint.com/SiteXXX/",[RelativePath="2020.xls"])

Best regards,

[Anonymous]

Hello @v-lid-msft ,

Thank you for the idea. Unfortunately, when I tried both positions of adding in "RelativePath" in Desktop I could not load the File. I am able to load the file without RelativePath but can not connect it to my Gateway.

Any other thoughts? 

Thanks, 

[GilbertQ]

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]

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]

What happens if you open the file directly from SharePoint Online and not via teams?

And then get the link from SharePoint online?

[Anonymous]

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]

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?