cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LarsRohlen Visitor
Visitor

Scheduled Refresh for online sources

Hi,

 

We are using the PowerPI Report Server (August 2018 version) and have created PowerBI reports with online connections to Smartsheet.

 

If we refresh the PowerBI reports in PowerBI Desktop, data from Smartsheet is updated correctly, but the reports published on the Report Server are only updated if we publish / saves the updated PowerBI report.

 

Is it possible to schedule a refresh of data from Smartsheet?

In "manage" for the report, Scheduled Refresh are not available/supported.

 

2 REPLIES 2
RobG Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh for online sources

I have the same question, trying to do the same thing as OP above.   Does anyone have an answer to this?   We have a need to schedule a refresh of Smartsheet data on the Power BI Report Server (On Premise).

NotJason Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh for online sources

We also have the same challenge. No one wants to manually refresh the Smartsheet data every day. But - currently there is no option as it isn't a supported data source for refresh by PowerQuery per this page here.

 

So we are exploring the option of creating a linked server object in SQL Server to bring in Smartsheet data over ODBC. No idea if that will work, but if the data can get into SQL Server, we can refresh from there no problem.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 316 members 3,090 guests
Please welcome our newest community members: