cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cflook00
Regular Visitor

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 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.

cflook00_0-1664889180876.png

 

cflook00_1-1664889215951.png

 

Am I missing something?

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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

d_gosbell_0-1664917266659.png

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.

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

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

d_gosbell_0-1664917266659.png

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.

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.