Forum Discussion

jmcgi2's avatar
jmcgi2
New Member
1 year ago
Solved

Python API - Create/Push New Dataset

I am pulling 2 different tables from Google Big Query. Then I am joining them together and manipulating the data. Finally, I need to push this new data to Power BI using my Python Script. I do NOT want to put my Pyhton Script into Power BI and run it that way.

 

Thank you in advance for any information!

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    You get the API key when you create your Streaming dataset.   Push datasets work a little different.

5 Replies

Replies have been turned off for this discussion
  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    All you need to do is call this API from your Python script. Doesn't even require authentication.

     

    curl --include \
--request POST \
--header "Content-Type: application/json" \
--data-binary "[
{
\"Host\" :\"AAAAA555555\",
\"Timestamp\" :\"2024-09-24T17:15:51.558Z\",
\"Available Memory in MB\" :98.6,
\"Processor Load %\" :98.6,
\"% Free on C:\" :98.6,
\"img\" :\"AAAAA555555\",
\"Mashups\" :98.6,
\"Mashup Memory\" :98.6,
\"Gateway Memory\" :98.6,
\"Proxy ok\" :98.6,
\"% Free on D:\" :98.6,
\"Users\" :98.6
}
]" \
"https://api.powerbi.com/beta/<tenant id>/datasets/<dataset id>/rows?experience=power-bi&key=<api key>"

     

    Note there is a slight difference between Push datasets and Streaming Datasets.

    • jmcgi2's avatar
      jmcgi2
      New Member
      1 year ago

      Thank you for the reponse. I work for Suabru and I believe I have to go by their security, would what you provided still work? I want to do it the correct way so IT does not get mad. Below is my code from reading the Power BI Python API. Let me know what you think!

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        you are missing the /rows  part of the URL.