Web.Contents Error

[Anonymous]

I've looked this issue up several times but have not found a solution that addressed my problem. I have a desktop Power Bi that is connected to several Smartsheet sheets and reports. I've had this running on auto-refresh for six months with no issue. Just today, I started receiving the following error that I cannot resolve. Any help?

Data source error: DataSource.Error: Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error. Microsoft.Data.Mashup.ErrorCode = 10117. DataSourceKind = Smartsheet. DataSourcePath = Smartsheet. Url = https://api.smartsheet.com/2.0/home. . The exception was raised by the IDbCommand interface. Table: Name of Table.
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: cda49f7e-13be-6468-9bcf-50bb698fc86e
Request ID: 842546cf-8f98-9ee1-21ce-7a7bfae47f0d
Time: 2025-03-20 14:41:10Z

[interimUser]

Hello, please see the below thread on Smartsheet Community. 

This is linked to an API deprecation that has crashed the Smartsheet Power Query connector

https://community.smartsheet.com/discussion/137509/internal-server-error-w-api-powerbi-connection/p2

[v-aatheeque]

Hi @Anonymous ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Anonymous ,

Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Anonymous ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[Anonymous]

Hi @Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[zbean]

Same issue here, starting last week.  We have tried to flush the credentials inside PowerBi, as well as the app credentials inside Smartsheet since it uses keys from that area vs the API user key.  Nothing has helped so far, and its sporadic as many users are not impacted. 

[Anonymous]

HI @Anonymous,

I suppose you may need to invoke login API to get the access token for other type REST API usages. You can also take a look at the official document to know more about these:

Smartsheet Developers - API login 

Regards,

Xiaoxin Sheng