PowerShell Invoke-RestMethod 404 Not found.

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?