Forum Discussion

cflook00's avatar
cflook00
Regular Visitor
3 years ago
Solved

Smartsheet Scheduled Refresh not available

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 t...
Auto Refresh
Help
power bi server
Smartsheet
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    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.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

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.

cflook00's avatar
cflook00
Regular Visitor
3 years ago

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