Governance limit in one workspace but not another. Same report...

[cathryn13]

Hi Everyone

I've hit a wall trying to determine what the cause is for this issue.

Scenario: 

We are not using capacity workspaces

We have a UAT workspace and a Production workspace

The same report, the same size is working differently between the 2 workspaces.  In Production, if I drill down on a matrix for a particular tab, I get a governance issue.  But that exact same report in the UAT workspace isn't experiencing the same issue.  In fact, the UAT workspace is using 507MB of the 10GB where Production, the one that is giving an error, is using only 396 MB.  All formulas are the same.  No one is using this report yet in Production so it's not a 'multiple hitting the report' issue.

Any ideas of what to check?  Or has anyone else seen this issue?

Thanks!

[GilbertQ]

Hi @cathryn13 

Could it be even though they are in different workspaces the datasets are larger which is causing the error to occur. If it only occurs on one drill down, what happens if you remove the matrix does it then work?

If it works, then the issue is with something on the matrix (possibly a measure which you would need to improve to not go over the governance issue)

[cathryn13]

Thank you @GilbertQ - I checked the sizes of the files and they are the same.  It's really strange. We published the exact same report into our UAT environment and then to our Prod within the hour so there are no differences.  I'm looking into the measure to see if we can improve it.

We have 3 tabs:

Year over Year

Quarter over Quarter

Period over Period

This is a P&L Matrix and all the same columns and rows for each one.  The period over period is what's giving the governance error.  We had to write a custom DAX measure since we couldn't use the DAX function for this.  Our periods are financial periods which don't  fall into the standard month over month.

[GilbertQ]

Hi @cathryn13 

You could create a date table which has got your financial periods and then you can use the built in time intelligence DAX functions to use the SAMEPERIODSLASTYEAR as an example.

You can search for Financial dates in Date table?