Free Support Forum - aspose.com

Accessing PowerQueryFormula results in exception of Invalid Power Query formula

We have the following file: Power Query Error.xlsx.zip (55.7 KB)
This file has 21 Power Query data connections. However, all connections raise an exception when accessing the PowerQueryFormula property.

Example code:

var workbook = new Workbook("Power Query Error.xlsx");
var externalConnections = workbook.DataConnections;

foreach (var externalConnection in externalConnections)
{
    var connection = (DBConnection) externalConnection;
    var powerQueryFormula = connection.PowerQueryFormula;
}

@infotron,
We have reproduced this issue here and logged it in our database for further investigation and a fix. You will be notified here once any update is ready for sharing in this regard.

This issue is logged as:
CELLSNET-47649 - Exception is raised while reading DBConnection.PowerQueryFormula from XLSX file

@infotron,

Please try our latest version/fix: Aspose.Cells for .NET v20.9.11 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.9.11 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.11 For .Net4.0.Zip (5.4 MB)

Yes, I can confirm that the issue is fixed in Aspose.Cells 20.9.11. Thank you!

@infotron,

Thanks for your feedback and good to know that your issue is resolved by the new fix.

The issues you have found earlier (filed as CELLSNET-47649) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (https://www.nuget.org/packages/Aspose.Cells/20.10.0).