Python custom table visual scrollable?

[Anonymous]

Hello everyone,

I am new to Python and Power BI so I hope someone can help me.

I created a simple custom Table using Python in Power BI:

import pandas as pd 
import matplotlib.pyplot as plt

fig, ax = plt.subplots() 
ax.set_axis_off() 
table = ax.table( 
    cellText = datatset.values,
    rowLabels = dataset.index,
    rowLoc = 'left',
    colLabels = dataset.columns, 
    cellLoc ='center',  
    loc ='upper left')         
   
fig.tight_layout()
plt.show()

The problem right now is that I would like to visualise many rows. In my custom table visual my data is displayed in a very condensed form because the table is not scrollable.

Is there a way to make a Python table visual in Power BI scrollable?

Thank you very much!

[Anonymous]

Hi @Anonymous ,

It may caused by this attributes:

fig.tight_layout()

Please delete it and have a try again.

And there is a data size limitation for Python visuals in Power BI Desktop: Data used by the Python visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.

Refer to:

Tight Layout guide — Matplotlib 3.1.2 documentation

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Docs

Solved: Python padding - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous,

thanks for your reply!

My input data contains approximately 200 rows and is less than 250 MB. So in general, no error occurs when trying to use the Python visual.

Also, once I remove fig.tight_layout() the table is just cutoff after 25 rows and the first column is not depicted completely. Is there a way to fix this and make the table scrollable in order to show all 200 rows?

Thanks in advance!

[Anonymous]

Hi,

Was this ever solved, I am facing a imilar issue too