Forum Discussion
power BI rest API with python
Hi Anonymous ,
Try to use Power BI REST API to push data from Json file into a Power BI dataset,check the reference below:
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Anonymous , I am not fully clear.
If you need call power bi API to python?
You need to power bi rest APIS
https://docs.microsoft.com/en-us/rest/api/power-bi/
Do you need to call Python in power bi?
How to make Python work with Power BI: https://youtu.be/5D0BkNsu5CM
These is limit what you can use for visual
https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/
Thanks for your reply!
This is my actual requirement
1. Creating an empty dataset using PBI API calls with python
2. Inseting some data from any file type like (json, csv, text etc..) into the newly created dataset with help of PBI API calls and python
3. Append the existing data with help of PBI API calls and python
I did all above steps with help of postman, and now we are trying to implement the same with help of python.
I did see the video you shared, I can create a table using python script from power BI desktop. But my requirement is using API calls need to create datasets and Insert data.
Hi Anonymous ,
Try to use Power BI REST API to push data from Json file into a Power BI dataset,check the reference below:
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data
Best Regards,
KellyDid I answer your question? Mark my post as a solution!