Forum Discussion
Solved
Power BI Rest API Internal Server Error 500
Hi, Power BI REST API is failing with 500 Internal Server Error from Apiary This is the API Add Rows: POST https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{...
The API works at the moment I post. Could you be more specific how you called it? I just tested the API with the dataset sample in this demo and it indeed added rows to the table in one dataset of one group. If the error still persists in your end, I'd guess it might be some issue on some cluster node then you'' have to create a support ticket.
By the way, the add rows API only works with the datasets created via REST API.
Ran accross the same issue. In my case someone left the company that owned the dataset and the connection was to a legacy system.
- Logged in as Admin
- Created a small table in an excel file and published that directly to the workspace
- Updated the app to add it and hide the one giving the issue
- Then in the workspace settings under Other I was able to delete the workspace
- (Also deleted the deployment pipeline 🙂 )
Good luck this was way longer to do than I wanted.
Guy in a Cube on YouTube also has one using powershell etc. for orphaned workspaces, I didn't need it but was going to do next.