Connecting to PB Dataset from Excel, but not pivot...

[michaelshparber]

Hi friends,

One of my dataset tables is very wide - many columns.

When I connect to the dataset from excel - it creates a pivot table and as I add more and more fields - the pivot slows down very much.

I don't need a pivot for this, just to get all the table from dataset as a simple table.

I don't mean export, I need direct live connection from excel to dataset.

I know it is possible, please help!

Thank you

[V-lianl-msft]

Hi @michaelshparber ,

Yes,  it will always use the PivotTable to extract data.

You might be able to do it with CubeValues

https://www.excelcampus.com/cubevalue-formulas/ 

The other way is what you are talking about exporting data.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[michaelshparber]

@V-lianl-msft  Thanks,

I think there a third way actually...

When I double-click a measure - it creates a new OLE DB connection (not OLAP)

And it uses DRILLTHROUGH query to return a TABLE (not pivot)

It is exactly was I am looking for, but I need a good reference on how to select easily any table from my dataset.

Please help

Thank you