Hi Dimitrios,
Thank you for using Syncfusion product.
Currently the reported requirement “Connect Olap database from local machine” isn’t available in pivot table. But, we have logged the requirement as feature in our database. And it will be available in any of our upcoming release. You can track it in following link.
We appreciate your patience until then.
Regards,
Sivamathi.