2 years ago

#6496

test-img

alcastaro

Connecting R or Python to an Analysis Services Cube (Microsoft)?

I'm trying to connect R or Python to an Analysis Services Cube. I usually access it through Excel Analysis Services, with the URL of the remote server and my username and password. You can see how I access it in the pictures below.

enter image description here

enter image description here

enter image description here

Thereafter I get a pivotable that allows me to make some queries. I need to do the same with R or Python, especially to import data. I tried to use olapR but I don't know how to set the server URL, username, and password. I also tried to use Python but it doesn't work for me.

Do you know if there is a tutorial or can you help me?

Note: I have "only read" permission, so I cannot change the configuration of the cube.

python

sql

r

analysis

cube

0 Answers

Your Answer

Accepted video resources