Forum Discussion
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, ...
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.