Forum Discussion

Malsha's avatar
Malsha
Icon for Helper I rankHelper I
3 years ago

Resources Exceeded Error in Power BI Service.

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...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

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's avatar
Malsha
Icon for Helper I rankHelper I
3 years ago

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?