Forum Discussion

jmcgi2's avatar
jmcgi2
New Member
2 years 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 wa...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

jmcgi2's avatar
jmcgi2
New Member
2 years 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
Icon for Super User rankSuper User
2 years ago

you are missing the /rows  part of the URL.

  • jmcgi2's avatar
    jmcgi2
    New Member
    2 years ago

     Ok I see that now. Could you let me know where to insert it into my string? I do not have an API Key, unless you are calling the API Key like the client_id or something. Thanks again!

     

    dataset_url = f'https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/datasets'
    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

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