Forum Discussion
Smartsheet and Data Gateway
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?
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
4 Replies
blopez11Super User
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
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
- v-eachen-msft
Community Support
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