Power Bi resource exceeded

[akshay2204]

Hi,

When I am viewing my power Bi report on power Bi service, I am getting an error message that resources has exceeded. I tried upgrading my account to premium but still can't load the visuals. Please suggest how we can add more capacity for premium users so that we can load the resources.

Thanks,

[akshay2204]

I am attaching here the sample dax query. We have lot's of dax queries like this

006_GP_NewProductImpact = DIVIDE(SUMX(VALUES(SalesCube[ProductCode]),(IF([004_CY_QTY]*[004_PY_QTY]*[001_CY Sales]*[001_PY Sales]=0,

    MAX([001_GPDelta],0),

    0

) )),SalesCube[000_Unit])

[cassidy]

Being on a Premium Capacity with visuals that exceed resources points to poor performance of the visual itself.  I'd look at reducing the amount of Data you are trying to display and ensuring DAX queries are efficient.

DAX Studio is a great tool for understanding the impact of DAX queries and working to reduce the resource usage

https://daxstudio.org/docs/features/traces/server-timings-trace/

If these visuals load while in Power BI Desktop, it's likely that your machine has more available Memory and CPU than your Capacity does.

[GilbertQ]

Hi @akshay2204 

I would check your model to make sure it is using the star schema as well as DAX measures that are as simple as possible?

[akshay2204]

I am attaching here the sample dax query. We have lot's of dax queries like this

006_GP_NewProductImpact = DIVIDE(SUMX(VALUES(SalesCube[ProductCode]),(IF([004_CY_QTY]*[004_PY_QTY]*[001_CY Sales]*[001_PY Sales]=0,

    MAX([001_GPDelta],0),

    0

) )),SalesCube[000_Unit])