I want to POST import a json file or json data into power bi service using rest api

Question

I am able to do POST import .pbix files into my workspace by appending my file as form-data and using the below endpoint
POST https://api.powerbi.com/v1.0/myorg/imports?datasetDisplayName={datasetDisplayName}
But, when I tried to do POST import .json using the same method as mentioned above, I got the below error

{
    "error": {
        "code": "InvalidRequest",
        "message": "Invalid dataflow structure. Exception details: <pi>Invalid model version: </pi>"
    }
}

Answer 1

The error message you received suggests that the structure of the JSON file you are trying to import as a dataflow may be invalid or not compatible with the version of Power BI that you are using.

Here are a few steps you can try to resolve the issue:

Check the structure of the JSON file: Make sure that the JSON file you are trying to import is in the correct format and contains all the required fields. You can compare it with a working JSON file to ensure that the structure is correct.

Check the version of Power BI: Make sure that the version of Power BI you are using supports the JSON file format you are trying to import. You can check the version of Power BI by going to "Help" > "About Power BI Desktop".

1. Try importing the JSON file using the Power BI Desktop: Try importing the JSON file using the Power BI Desktop application to see if you get any error messages. This can help you identify any issues with the file itself.