Resources Exceeded Error in Power BI Service.

[Malsha]

Hi everyone,

I'm getting this error in power bi service and desktop when adding columns to my table visual.

In my table there are more than 100 columns. is there a visual limitation? what can I do to solve this issue and client doesn't like to change the format also. so he needs all the columns in a one table visual.

Can anyone please give a solution to this.

[sergej_og]

Calaculated columns can actually cause performance issues.
If you need them try to build them as far forward as possible. In PQ or in database statement.
Try to avoid build many culculated columns with DAX. 
But your table is quite small, 400-500 records.

What does the build-in performnace analyzer (Power BI Desktop) said?
What metrics do you get while refreshing you table...and other visuals on your report page?

And what happens to performnace (error notification) in Service when you would display (deploy) only 10 columns?

[sergej_og]

Wow, > 100 columns in a PBI table visual...crazy.
I guess you have a Pro license?
It looks you are running out of available RAM capacity given to each Dataset.

 - If you are rendering more than 100 columns it is bit work for Service to do this. Really necessary?
Maybe is a connection via Excel to your dataset a better way to visualize the data.
 - did you checked your datamodel for table relationships (n:m, biderictional etc.) or for heavy Measure calculations?

Regards

[Malsha]

Hi Sergej_og,
Thank you for your support. 
Actually yes, client need to see all the columns in a one table in power bi. I checked my datamodel relationships. they are fine. Bt I'm using some calculated columns for this report also. bt table contains like 400-500 records and most of the columns are blank columns which I created using dax like this.
Column1 = blank()

Do you have any idea about this?