Connecting to MSOLAP cube trough DBI

Question

I would like to connect to a Microsoft Olap Cube using the 'DBI' interface instead of the MCRAN package 'olapR' because it is only available on Windows version and therefore I cannot containerize it when my work is done.

So far I tried:

con <- DBI::dbConnect(odbc::odbc(),
Driver   = "MSOLAP",
Server   = "xxx.net",
Database = "yyy",
UID      = "")

But with no luck.

Provided that the connection string I use in Excel is:

Provider=MSOLAP.8; Integrated Security=SSPI; Persist Security Info=True; User ID=""; Initial Catalog=""; Data Source=xxx.net\yyy; Location=xxx.net