Power Platform Community Forum Thread Details

Hi, 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.

Categories:

Using connectors