Python padding doesn't work in Power BI Service

[Anonymous]

Hi all,

I am using python to built a boxplot graph. As you may know, padding in python is not that good so in order to improve my graph size I am using plt.tight_layout(). This works perfect in PBI Desktop but once I publish my report, the original padding comes back. 

This is my first work in power bi using python, Am I missing something?

Thanks,

Cesar

[Anonymous]

Hi @Anonymous ,

I'd like to suggest you to take a look at following blog about power bi and python script:

Python visualizations in Power BI Service

Spoiler

The Python scripts in your reports are executed by the Power BI service in an isolated sandbox that restricts the access of the scripts to the network and the other machine resources. This ensures that your datasets and the Power BI service are not vulnerable to attacks.

As document said, all python script execute in a sandbox and power bi will block the access of extra resources. It may block some functions work on power bi service side.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi Xiaoxin,

I found the solution, for boxplots instead of using plt.tight_layout() I needed to use plt.figure(figsize=(20,5)).

It is not a perfect option because there is still some non-optimized surrounding spaces, but at least it works with PBI services.

Regards,

Cesar