Forum Discussion

akshay2204's avatar
akshay2204
Frequent Visitor
3 years ago

Power Bi resource exceeded

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. ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

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's avatar
    akshay2204
    Frequent Visitor
    3 years ago
    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])