Forum Discussion
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/rows 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
The REST API article updated on July 21, 2017, there should be no changes made for the delete rows action:
Example:
DELETE https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rowsMake sure you didn't disable the "historic data analysis", and take a try with a newly added row for testing purpose.
Regards,
Michael
2 Replies
The REST API article updated on July 21, 2017, there should be no changes made for the delete rows action:
Example:
DELETE https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rowsMake 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
