topic Smartsheet Scheduled Refresh not available in Report Server

Smartsheet Scheduled Refresh not available

cflook00 — Tue, 04 Oct 2022 13:49:22 GMT

I am using the certified Smartsheet data connector to connect Power BI to Smartsheet (cloud solution). I am able to refresh the report fine from within Power BI Desktop. The problem comes when I go to create a scheduled refresh it says it does not recognize the Smartsheet connection as an external data connection. I've searched through all of the Power BI help (please do not link the unsupported data types as I am either missing something or it is not making sense) and I can't find why this shouldn't work.

From the screenshot below it looks like refresh from service is available... it says gateway is not required.

Am I missing something?

Re: Smartsheet Scheduled Refresh not available

d_gosbell — Tue, 04 Oct 2022 21:02:30 GMT

So the screenshot you are showing is from the Power BI Service (the cloud version) not from Report Server (the on-prem version)

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

Unfortunately SmartSheet (and most other cloud based sources) are not supported for scheduled refresh when using the on-prem report server. If you have a mix of on-prem and cloud based data the general advice is to publish your reports to a cloud based workspace and use a data gateway for the on-prem data.

Re: Smartsheet Scheduled Refresh not available

cflook00 — Tue, 04 Oct 2022 21:09:21 GMT

Wow that is unfortunate... thank you for the response though that makes sense.