Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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.
@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