Internal Server Error w/ API PowerBI connection.

Torrey · 03/25/25

I have been experiencing these issues since Friday 3/14/25 with no solution.

PDunn · 03/25/25

Same here been happening since last Thursday 3/20/25

Randy Saad · 03/25/25

https://community.smartsheet.com/discussion/comment/477571#Comment_477571

@Georgie "We are not able to provide a time-frame on how long the resolution could take" Are we talking hours? Days? Weeks? Do we all need to start recreating our reports and processes? Or can we expect a resolution to this issue soon?

Bobbie Burns · 03/26/25

I am also being impacted and this is a major disruption in our required reporting. Please provide timely updates on progress getting this issue addressed. It started happening yesterday 3/25/25 around 2:00 ET

Javier Cuesta_UPL · 03/26/25

https://community.smartsheet.com/discussion/comment/478035#Comment_478035

The original post is from 21, so days the least. If we look into other people feedback, there are users experiencing problems from 14th March… so that points to weeks. Your question is relevant, should we start looking for something else?

truyenh · 03/27/25

Apparently, Smartsheet deprecated the folder /Sheets and /home endpoint scheduled to be in June but it somehow causes this issue: https://developers.smartsheet.com/api/smartsheet/changelog#2025-03-25 .

2025-03-25

DEPRECATION:

We deprecated the "Sheets" folder and are replacing it with Workspaces for a more streamlined experience.

We're providing access to the following API endpoints associated with the "Sheets" folder until June.

As part of this deprecation, we deprecated the home destinationType enum in folder and sheets endpoints.

Learn how to update your code to these changes at Migrate from using the Sheets folder.

Sam_M · 03/27/25

Even I am having the same issue, started on 3/25/2025 suddenly. Anyone got solution or workaround for it !! And is this problem only for US users?

truyenh · 03/27/25

Depend on the api that you use for your application. If your app is affected by the endpoint /home, here is the suggested workaround: Migrate from using the Sheets folder

Migrate from GET /home

The GET /home method is deprecated and will be removed. The method lists the child items of the user's "Sheets" folder.

Here are steps for migrating from the GET /home method to using Workspaces.

As described in the first section above, move all items and folders from the user's "Sheets" folder to a Workspace.
Use the following methods to fetch items from Workspaces:
- GET /workspaces lists the user's Workspaces.
- GET/workspaces/{workspaceId} fetches the Workspace's children.

Prateek_UPL · 03/27/25

@Georgie

How long do we have to wait until we get the issue resolved, It been 3 days we have raised the ticket and there isn't a single response. Should we just keep waiting on a daily basis with no objective of getting this issue resolved. This has caused a huge delay in the process with no where to go

Georgie · 03/27/25

@DQ Aaron, @BorisM, @Michele Messina, @Ermanno, @rafael.castellanos, @James Keuning, @angad.sodhi, @Randy Saad, @Javier Cuesta_UPL, @Vinicius Cassiano, @Nick.Panek, @gzimmer2, @Torrey, @PDunn, @Bobbie Burns, @truyenh, @Sai Satya Vinay, @Prateek_UPL

Hi all,

Thanks for your patience on this. I can confirm that our Support team is actively working on a fix for this issue. They have now identified a temporary solution whilst they continue to investigate a more permanent fix, and this requires a backend change - please submit a Support ticket so that the team can make the change for you and keep you updated.

Thanks,

Georgie

Javier Cuesta_UPL · 03/27/25

https://community.smartsheet.com/discussion/comment/478270#Comment_478270

Hi Georgie,

Thanks for your feedback.

Please note that I already opened a ticket for this issue, Case Number 08073994 (back on 25th March when the problem started)
I have separately received an email from support@smartsheet.com (with no link to the ticket, but I presume more linked to this community chat) ofering me to have this temporary fix for the connection to Power BI, but when I replied to it I received an automated reply saying that the mentioned email address was not active anymore. As I haven't recived a reply yet I have no way to know if you have got my response, where I would confirm you that UPL wants that workaround not matter the secondary effect it may involve with Workapps interface.

This message forms part of my effort to connect all the different communications happening around this issue, in the hope that this will clarify and speed up the solution to it. Please confirm the course of action I should follow:

Should I open yet a new ticket to get the workaround patch? otherwise, is there anything else I can do to speed up the process of getting support?

Thanks in advance for your further support

Javier

Randy Saad · 03/27/25

Can anyone who submits a ticket to get the temporary solution applied update this thread when they have confirmed that the solution actually works?

kgree106 · 03/27/25

What is the timeline for this to be fixed?

We rely on Smartsheet for a report in PowerBI. This is now not working. I can see multiple posts about this issue.

We need to be able to trust this product for our operations. A small step, when an error like this occurs, is to let us know when we can expect a fix. This isn't because we're curious, it's because our leaders and teams are asking.

Koleen Steiner · 03/27/25

Reporting we are experiencing the same issues beginning with 3/25 and no response on the support @ email when attempting to open a ticket.

Georgie · 03/27/25

https://community.smartsheet.com/discussion/comment/478289#Comment_478289

@Javier Cuesta_UPL and @Koleen Steiner,

Please ensure that you use the Customer Support Portal to submit and track your support tickets - you'll be able to follow up on existing tickets there and add any further information directly onto the ticket. You can also track multiple requests at one time. This will ensure that your responses are routed directly to the Support team.

Thanks,
Georgie

API & Developers

API & Developers

Internal Server Error w/ API PowerBI connection.

Answers

2025-03-25

Quick Links

Categories

Trending in API & Developers

Internal Server Error w/ API PowerBI connection.

VBA to Smartsheet

Summary field with formula by API