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

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?