Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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}/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
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}/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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |