PowerBI Connector has intermittent issues (due to smartsheet network?) - Anyone having similar issue

RichardJ ✭✭
edited 02/19/24 in Add Ons and Integrations


Is anyone else having issues with using the Power BI Connector to access Smartsheet data in the last couple of weeks. The network performance seems to be extremely sporadic and is getting worse.

Nothing has changed in the configuration of the PowerBI dataflow nor in the amount of data being requested.

Errors when they occur suggest the issue is a lack of response from Smartsheet

"DataSource.Error: Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/reports/......."

" (500): Internal Server Error DataSourceKind = <ccon>Smartsheet</ccon>"

I've a hunch that the issue may be specific to data which is being sourced from a Smartsheet Report (which are used to consolidate sheets into a larger data set).

The fact that the load works sometimes and sometimes not suggests it's a network issue rather than a configuration issue.

Is anyone else experiencing this issue.