Forum Discussion

AmilaGunawardan's avatar
AmilaGunawardan
Frequent Visitor
3 years ago
Solved

Power BI Rest API Refresh Dataset gives 404 error

HI, I have created a PowerShell file to refresh the automation of a Power BI dataset. This below snippet worked for a few days and suddenly gave the below error. VERBOSE: POST https://api.powerbi....
Need Help
  • AmilaGunawardan's avatar
    AmilaGunawardan
    3 years ago

    This was fixed by adding the relevant AD group to the workspace as a member. 

  • AmilaGunawardan's avatar
    AmilaGunawardan
    3 years ago

    This error happened because the service principle access got revoked without a warning.

AmilaGunawardan's avatar
AmilaGunawardan
Frequent Visitor
3 years ago

Hi,

 

  1. I can confirm that Service Principle is active, and access token is generated.
  2. I have replaced the dataset, but haven't deleted the data set. Because of that, dataset ID was not changed. I have manually checked for any changes of dataset ID.

I will include the Resolve-PowerBIError output below for easier debugging

 

Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 29


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (403) Forbidden.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (403) Forbidden.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (403) Forbidden.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (403) Forbidden.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     : {"Message":"API is not accessible for application"}
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (400) Bad Request.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (400) Bad Request.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (400) Bad Request.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (400) Bad Request.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (403) Forbidden.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (403) Forbidden.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     : {"Message":"API is not accessible for application"}
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 30


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 29


Exception        : System.Net.WebException: The remote server returned an error: (403) Forbidden.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (403) Forbidden.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     : {"Message":"API is not accessible for application"}
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 29


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27


Exception        : System.Net.WebException: The remote server returned an error: (404) Not Found.
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
InnerException   : False
Message          : The remote server returned an error: (404) Not Found.
StackTrace       :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
                      at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
HelpLink         :
Source           : Microsoft.PowerShell.Commands.Utility
ErrorDetails     :
ErrorCategory    : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
InvocationInfo   : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, <No file>: line 27

 

  • AmilaGunawardan's avatar
    AmilaGunawardan
    Frequent Visitor
    3 years ago

    This error happened because the service principle access got revoked without a warning.