I am having trouble updating parameters within the DataMashup > PowerQueryFormula. Currently any PowerQueryFormulaItem > Value that I update, I get an error when I try to save the workbook:
System.NullReferenceException: ‘Object reference not set to an instance of an object.’
**Please note that I am working with Web.Contents by getting data via an API call and this error happens when I call workbook.Save. If I open the workbook and Save without modifying the PowerQueryFormulaItem > Value, it works fine.
Separately, I am also getting an error when trying to RefreshData on the Pivot Table, and am getting the error:
Aspose.Cells.CellsException: ‘this data source is not supported.’
(I am using the Power Pivot Add In, which also might be causing an issue)
If you can let me know if there are current limitations as I know this is a new feature for Aspose. I am more than willing to work with you to test in order to figure out a way to automatically refresh API calls within Power Query, while updating the parameters. This is a super powerful feature that would give Aspose quite the edge to be able to support this. It would make our old reporting methods basically obsolete, where we wouldn’t have to configure everything in C# .Net code!