PowerShell Invoke-RestMethod 404 Not found.

XIOFEN_LIM — Wed, 31 Mar 2021 02:23:56 GMT

Hi All,

In the process for loading up data streaming from SQL server to monitor live data and possibly create a dashboard. However after setting up the dashboard and a powershell script to push data to power bi, error shown.

Invoke-RestMethod : The remote server returned an error: (404) Not Found.

At C:\Users\EEM02117\OneDrive - Escatec\Projects\Power BI\POC\PushData.ps1:46 char:2

+ Invoke-RestMethod -Method Post -Uri "$Endpoint" -Body (ConvertTo- ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebExc

eption

+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

Here’s the powershell script that pushes the data:

$Endpoint = https://api.powerbi.com/beta/1ee0c8fe-fb94-4c61-80fa-6d0ec79dc31f/Datasets/6062d4fe-7200-4b41-87f5-41b07611193e/rows?key=S1P5IlzbpH%2BWcq69EuUe7vfHo7EsQYjAVIHgjw%2Fdl%2FSItroJygTjbrPILhqfFyOr1ZvD%2F9%2FQcUohQsaSbkKngg%3D%3D

while ($Dataset.Read()) { #push data to Power BI

$payload = @{

"UnitId" =$Dataset['UnitId']

"SerialNumberInternal" =$Dataset['SerialNumberInternal']

"SaleQuantityAmount" =$Dataset['Quantity']

"DateCreated" =$Dataset['DateCreated']

}

Invoke-RestMethod -Method Post -Uri "$Endpoint" -Body (ConvertTo-Json @($payload))

}

Any ideas? Would need a Power BI gateway configured?

Re: PowerShell Invoke-RestMethod 404 Not found.

V-lianl-msft — Mon, 05 Apr 2021 02:17:41 GMT

If it is a non cloud data source, you need to configure a gateway.

Make sure you didn't disable the "historic data analysis".

You can also refer to the steps of this blog:

https://sqlitybi.com/streaming-data-from-sql-server-to-power-bi-using-powershell/?doing_wp_cron=1617588238.1943280696868896484375

Re: PowerShell Invoke-RestMethod 404 Not found.

XIOFEN_LIM — Mon, 05 Apr 2021 02:54:48 GMT

@V-lianl-msft

Got it.. Thank you!

topic PowerShell Invoke-RestMethod 404 Not found. in Developer

PowerShell Invoke-RestMethod 404 Not found.

Re: PowerShell Invoke-RestMethod 404 Not found.

Re: PowerShell Invoke-RestMethod 404 Not found.