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

RichardJ

Hi,

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.

Thanks

RichardJ

Question also asked on the Fabric/PowerBI community

Smartsheet Connector - anyone else been having ref... - Microsoft Fabric Community

Genevieve P.

Hi @RichardJ

Is this still happening for you today? Smartsheet was experiencing intermittent connectivity on February 7th and 8th which would have impacted integrations. Here's more information:

https://status.smartsheet.com/

Cheers,

Genevieve

RichardJ

Thanks for the response @Genevieve P. The refreshes have been far more stable recently.