cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jyeager
Frequent Visitor

SmartSheet as a Power BI Service Data Source (and how to schedule refresh)

Hello All. Cuirous if anyone can help me with the following? 

 

Background: I created a report in Power BI Desktop that contains data sfrom a couple of Excel sheets (not required to be updated on any frequency) and data from two worksheets within SmartSheet. The data in the SmartSheet worksheets is updated periodically by users in SmartSheet. I then suck that data into Power BI for use in my report. I have published the report to Power BI Service so that other individuals in my organization can view the information. Its all working pretty well and we are happy with the results thus far.

 

Problem/Issue: I would like to schedule the refresh of the SmartSheet data. Right now, I have to manually refresh in Power BI Desktop and then re-publish to Power BI Service. Is there a way to establish the SmartSheet worksheet dataset in Power BI Service? And then configure to refresh on a scheduled basis? From what I have read, I dont think I need a gateway or anthing to do this but I could be wrong. 

 

Note: I have seen a few other posts regarding this on the Community, however I am not seeing the functionality/configurations mentioned in those posts currently in Power BI Service. So I think there amy have been an update to Service since those original posts were created. 

 

Any insight or help would be much appreciated! Thank you!!

 

JY

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: SmartSheet as a Power BI Service Data Source (and how to schedule refresh)

@jyeager

 

Currently, power bi only support schedule refreshing cloud data source which are listed in power query. Please refer to link blow:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh#whats-supported

https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshoot-unsupported-data-source-for-ref...

 

Regards,

Jimmy Tao

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: SmartSheet as a Power BI Service Data Source (and how to schedule refresh)

Hi jyeager,

 

Yes, if your data source is local source, you need a on-premises data gateway or personal gateway. About how to install and configure data gateway, Please refer to documentation: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem. In addtion, after gateway installed, to set schedule refresh in power bi service, select the ellipsis (...) next to a dataset listed under Datasets then Select Schedule Refresh. Please refer to: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh.

 

Regards,

Jimmy Tao

jyeager
Frequent Visitor

Re: SmartSheet as a Power BI Service Data Source (and how to schedule refresh)

Thank you for the response and help! The data source I am concerned with is a cloud source (smartsheet.com), so I dont think I need the on-premise data gateway. Is there a way to link to a cloud data source directly and configure a scheduled refresh?

 

JY

Community Support
Community Support

Re: SmartSheet as a Power BI Service Data Source (and how to schedule refresh)

@jyeager

 

Currently, power bi only support schedule refreshing cloud data source which are listed in power query. Please refer to link blow:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh#whats-supported

https://docs.microsoft.com/en-us/power-bi/service-admin-troubleshoot-unsupported-data-source-for-ref...

 

Regards,

Jimmy Tao

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.