Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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-4...
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?
Solved! Go to Solution.
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:
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:
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |