Hello,
currently we moved to Office 365 ProPlus (Version 1708) and if we try to filter by using the PivotTable Extensions the following error is thrown:
After further analysis the connection string is responsible. We use the property "Application Name" for adding a name to the connection for use in e.g. SQL Profiler. In Office 365 ProPlus an additional property "App" is automatically generated and can't be removed from the connection string.
Connection string:
Provider=MSOLAP.8;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Vertrieb_Cube;Data Source=SQLSSAS\ServerName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Application Name=Excel MS BI Vertrieb und Marketing DE;App=Excel MS BI Vertrieb und Marketing DE;Update Isolation Level=2
The PivotTable Extensions version used is 0.9.0.0 (32-bit).
Thank you in advance,
cbracht
Hello,
currently we moved to Office 365 ProPlus (Version 1708) and if we try to filter by using the PivotTable Extensions the following error is thrown:
After further analysis the connection string is responsible. We use the property "Application Name" for adding a name to the connection for use in e.g. SQL Profiler. In Office 365 ProPlus an additional property "App" is automatically generated and can't be removed from the connection string.
Connection string:
Provider=MSOLAP.8;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Vertrieb_Cube;Data Source=SQLSSAS\ServerName;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Application Name=Excel MS BI Vertrieb und Marketing DE;App=Excel MS BI Vertrieb und Marketing DE;Update Isolation Level=2
The PivotTable Extensions version used is 0.9.0.0 (32-bit).
Thank you in advance,
cbracht