Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Chas2002
Helper III
Helper III

Did MS change something on APIs?

 

My powershells worked for months -- pushing real-time streams to tiles on a dashboard.

 

All of a sudden I'm getting this:

 

VERBOSE: DELETE https://api.powerbi.com/v1.0/myorg/datasets/132e1621-21b0-484c-8e0c-776f3e79f169/tables/RealTimeData... with 0-byte payload


Invoke-RestMethod : The remote server returned an error: (404) Not Found.
At C:\Users\David\Desktop\PowerShell_Failed.ps1:164 char:15
+ $result = Invoke-RestMethod -uri $url -Headers $headers -Method Delete

 

It's as thought it's not authenicating or powershell cant get to the https site?  I know the dataset is correct because I can push data to it -- I just can't delete rows from the table.

 

The only thing new:  I changed from a free trial to a pro trial...

 

Arghh!! Any help would be appreciated.

 

Thanks,

Chas

1 ACCEPTED SOLUTION
v-micsh-msft
Microsoft Employee
Microsoft Employee

The REST API article updated on July 21, 2017, there should be no changes made for the delete rows action:

Delete Rows

 

Example:

DELETE https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

Make sure you didn't disable the "historic data analysis", and take a try with a newly added row for testing purpose.

 

Regards,

Michael

View solution in original post

2 REPLIES 2
v-micsh-msft
Microsoft Employee
Microsoft Employee

The REST API article updated on July 21, 2017, there should be no changes made for the delete rows action:

Delete Rows

 

Example:

DELETE https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

Make sure you didn't disable the "historic data analysis", and take a try with a newly added row for testing purpose.

 

Regards,

Michael

HI Michael,

 

I did check as you suggested and history was on, but it helped me find the issue.  I had moved the Datasets, Reports, and dashboard to a new Workspace -- My powershell, which pushes the real-tme data, was referencing MyWorkspace dataset location without group or workspace id... 

 

Corrected the powershell, authenicated and data was on the move..

 

Thanks,

Chas2002

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors