Hello,
I have had the same dataflow connected to a Smartsheet report for months and suddenly it is not refreshing anymore.
Error: Error: DataSource.Error: Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/reports/874834112419?pageSize=500&page=460' (500): Internal Server Error Request ID: 7bb7ade0-aa0f-80d3-348d-2e3c6c9f2ed7 Activity ID: 92a5870d-07a0-463f-91d9-b32482ea1d82
This only happens when I try to connect the dataflow with Reports from Smartsheet and not to the Worksheets.
Curious is that when I try to build the dataflow and perform ETL everything runs perfectly, data is being retrieved. But when I save the dataflow and refresh it, it faills and I receive the afore mentioned error.
In few words, only the blue icons work but not the orange ones.