Forum Discussion
Chris1880
Jul 02, 2024Copper Contributor
OLAP connection Open XML adds x: namespace which is preventing slicer to work
I serialise the excel workbook with C# OpenXml to dynamically change the connection.xml file so users can connect to olap cube tabular in pbi. So I programmatically set a connection string for the u...
PhilKcrow
Aug 17, 2025Copper Contributor
Remove the xmlns:x namespace from the OLAP connection string in Excel, or regenerate the connection using Power Query instead.