We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Power Query Parameters and Refresh Pivot Table

The issues you have found earlier (filed as CELLSNET-47435) have been fixed in Aspose.Cells for .NET v20.7. This message was posted using Bugs notification tool by ahsaniqbalsidiqui

In your next release, could you please change Parameter Items to be editable? It looks like they are ready-only currently. This would make it easier to separate Parameters from Formula items.
image.png (5.5 KB)

Ease of use for developers will go a long way when using Power Query/Power Pivot in .NET.

Also, I am having trouble generating a refreshed version of the report with the new parameter. What is the correct way to Refresh All? Or is this not supported?


We have created a separate ticket for this as follows:
CELLSNET-47489-Provision to edit PowerQueryFormulaParameters

Could you please create a new thread along with the runnable sample code and template files for our reference? Provide complete details with images and steps so that we may reproduce the issue here and provide feedback accordingly.

Thank you, and here is the link to the new item:

We have replied this query and observed that it is the same issue which is already logged. We will update you when any information is available in this regard.


This is to inform you that we have fixed your issue “CELLSNET-47489” now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v20.7.2 (attached)
Aspose.Cells20.7.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.2 For .Net4.0.Zip (5.4 MB)

Your issue “CELLSNET-47489” should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-47489) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi

Good afternoon, I just wanted to know if there has been any progress on CELLSNET-47434?

Are we still looking at a September implementation?


Due to complexity of the issue, it is not resolved yet. We are gathering more information about it and will share feedback once any further update is ready for sharing.

This feature is complicated, We will support it in the second quarter of 2021.

Is this feature still on the hook for second quarter 2021?


Yes, hopefully the feature will be supported before the end of Q2, 2021. Once we support it, we will notify in this thread.

1 Like

Could you please give an update for this item so that our team can decide the best course of action? If it is not ready, we will have to adjust for imminent projects.


We are gathering the information and will get back to you with latest updates on it (“CELLSNET-47434”).

We have tried our best to analyze this feature. Due to the incomplete technical documents, many important technical points cannot be broken through, such as data encryption and decryption, data organization and internal logic, etc. We also tried to guess and implement the internal logic of the feature based on experience, but we failed to implement the requirement in the end. We will continue to explore the implementation of this feature, but we cannot provide a specific time. So we can’t support this feature for the time being and apologize for the inconvenience.