I have dataset of 10million..and this data has been consumed by Pivot table and date field is being pivoted...which is taking lot of time to display..literally hanging the application and refreshing back to landing page. Please let me know if you have any solutions or any other alternative approaches to resolve performance issue.
Thanks for sharing it. As it is limited set and also not sure what your data model actually looks like. It will be difficult to replicate scenario and know what may be impacting. I've tried recreating pivot table.
Please advise what your scenario looks like, if it is different then what I've done so far. Expression, data model, etc.
I was on vacation, sorry for the delayed response.
I reviewed the app you have prepared with data I provided and its right. Now since same data in my data model takes approx. 5-6 to load entire data, however there is a chances of refreshing the entire application. I am repeating same, my data model has huge number of records, like ~10 million. No complicated expression in pivot too. Lets say now you increase same data by 5 times. I am very sure performance will take a hit.
I know you may ask to handle in data model to load faster, expect the pivot chart rest other objects loads faster. So I need your input for alternative solution or techniques to load pivot faster. Any thoughts?