Forum Discussion
【API CALL】 Python scripts return nothing
Hi guys,
I have two python scripts. Both https links are worked when I use them as "Web" sources.
However, when I try to use them as "python script" source, they return nothing and shows "no item selected for preview".
I tried these two scripts on my local CMD prompt with python, they returned the web pages successfully.
I am not sure that is the failure because these two websites are on my company's internal server? If so, why I can use "web" source to get data in power bi?
Hi Anonymous ,
Based on my research, it does support other package, but imported data must be in a pandas data frame, you can refer to thread about how to store result in the PD data frame.
Best regards,
4 Replies
Hi Anonymous ,
Based on this document, The Power BI Python integration requires the installation of two Python packages: Pandas and Matplotlib
When preparing and running a Python script in Power BI Desktop, there are a few limitations:
- Only pandas data frames are imported, so make sure the data you want to import to Power BI is represented in a data frame
- Any Python script that runs longer than 30 minutes times out
- Interactive calls in the Python script, such as waiting for user input, halts the script’s execution
- When setting the working directory within the Python script, you must define a full path to the working directory, rather than a relative path
- Nested tables are currently not supported
Best regards,Hi v-lid-msft ,
Thank you for replying. I have read this document .
Do you mean that, so far Power BI Python only support Pandas and Matplotlib packages?
Because I don't think these two packages can be used for API CALL.
Does that mean Power BI Python not support web API data pulling?
Hi Anonymous ,
Based on my research, it does support other package, but imported data must be in a pandas data frame, you can refer to thread about how to store result in the PD data frame.
Best regards,