Random results after PivotTable refresh.
A funny thing happend to me lately…
A user (manager) came to me with a PivotTable his predecessor created that produced random results after refreshing.
The PivotTable was based on a PivotCache connected to a query on a SQL Server.
When the query was run in Management Studio it was complaining about a conversion and returned a error.
This query didn’t produce a error in excel but just returned the records upuntil the error.
As the query wasn’t sorted the number of records returned to excel was random as so the results in the PivotTable.
If after the first refresh the data was almost complete nobody would have noticed the corrupt results
Hope I this helps anybody having the same issue….
p.s. Self Service BI is not for everybody …