Share
ReportHi, l am using Insert Row (v2) then Refresh a data set connection.
Objective : When SQL receives data, POST update my Power Bi report and Power Bi Data Set to see in real time to see the change reflected.
When l use the data import type, input, l get the error of 202, Pragma no-cache.
Error Code Below, for data import type.
{
"statusCode": 202,
"headers": {
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "deny",
"X-Content-Type-Options": "nosniff",
"RequestId": "954c7c4e-8db5-40ef-b69c-0e2db5da8125",
"Access-Control-Expose-Headers": "RequestId",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "true",
"Cache-Control": "no-store, must-revalidate, no-cache",
"Date": "Mon, 26 Sep 2022 04:08:55 GMT",
"Content-Length": "0"
}
}
When l use direct query as the data import type l get a error of 415. For this variation l get a error in the header and body.
{
"statusCode": 415,
"headers": {
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "deny",
"X-Content-Type-Options": "nosniff",
"RequestId": "13d99092-eb48-4ac6-9cef-1fee6ff6a9a4",
"Access-Control-Expose-Headers": "RequestId",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "true",
"Cache-Control": "no-store, must-revalidate, no-cache",
"Date": "Mon, 26 Sep 2022 04:16:53 GMT",
"Content-Length": "142",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": "InvalidRequest",
"message": "Invalid dataset. This API can only be called on a Model-based dataset"
}
}
}
Which data import type should l use to fix this problem as neither works right now. And how do l fix those error codes.
All responses (
Answers (
497
