Smartsheet and Data Gateway

[Anonymous]

Hello Everyone,

I'm trying to build a report connect to smartsheet. In power BI Desktop I am using the Smartsheet connector and it publishes fine, but when I set up data gateway, I have received the following error. Can anyone help me with how to set up a gateway for smartsheet?

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

If you have on-premises and cloud data sources at the same time, you could refer to this document:

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

[blopez11]

I don't believe you even need to use a gateway as smartsheet can be access through the web, you just need to supply your credentials

[Anonymous]

Hi @blopez11 , 

Since my report contains other sources as well (excel and sharepoint list), how can I set it up to auto refresh?

[blopez11]

For each data source, you can specify whether you want to configure to use the gateway or not.  So for the Excel, you can specify a gateway.  I am not too sure about the Sharepoint list.  I've pulled files from Sharepoint online without the need for a gateway, but I don't know about the lists