Forum Discussion

aoliver's avatar
aoliver
Helper III
6 years ago
Solved

PowerBI Service with Python as Data source

Hello everyone,  I use a python script as a datasource in a report. In desktop version works fine. The problem is when I try to refresh it in powerBI Service, I have a lot of doubts: It is possib...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi aoliver ,

     

    Based on this document, It is not supported to implement schedule refresh via on premise Data Gateway (Enterprise Gateway) for Python in Power BI Service currently .

     

    • To enable scheduled refresh of your Python dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation. 
    • You'll need to have the pandas library installed in your Python environment for the previous script code to work properly.
    • For the Python scripts to work properly in the Power BI service, all data sources need to be set to public.
    • Nested tables (table of tables) are currently not supported

    Based on my research, Python script execution on the Power BI Desktop and personal gateway has the same dataframe size and PNG image size limits, but the execution time limit is 300 seconds. Other constraints are not applicable to Power BI Desktop and personal gateway. Please refer to this blog: https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi aoliver ,

 

Based on this document, It is not supported to implement schedule refresh via on premise Data Gateway (Enterprise Gateway) for Python in Power BI Service currently .

 

  • To enable scheduled refresh of your Python dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation. 
  • You'll need to have the pandas library installed in your Python environment for the previous script code to work properly.
  • For the Python scripts to work properly in the Power BI service, all data sources need to be set to public.
  • Nested tables (table of tables) are currently not supported

Based on my research, Python script execution on the Power BI Desktop and personal gateway has the same dataframe size and PNG image size limits, but the execution time limit is 300 seconds. Other constraints are not applicable to Power BI Desktop and personal gateway. Please refer to this blog: https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/


Best regards,

 

aoliver's avatar
aoliver
Helper III
6 years ago

Thanks for all your answers!!!

Cheers