How to connect to cube databases in alteryx

Question

Hi

I have to extract data from cube databases using Alteryx. I have searched some info and understood that Alteryx doesn't support the connectivity to cube databases directly. I tried few methods using MSOLAP Provider but no success. Is there any way to connect to cube kind of databases from Alteryx?

Thanks in advance,

Deepika

deepika_durvasula · Answer

Hi,

I have tried this method, but I am facing 2 errors:

1. Error: MDX (5): Tool #23: The entry point is invalid.

2. Error: MDX (5): Tool #11: The external program "%temp%\mdxQuery.bat" returned an error code: 1

Could anyone please help me in solving this issue.

Thanks in advance.

Deepika

caltang · Answer

What abou this? With a macro: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/SSAS-Cube-Connection-and-MS-Power-Query/td-p/13405

@deepika_durvasula

deepika_durvasula · Answer

Hey thanks for the reply.

I have tried using that method. But couldn't find any success. Any other approaches other than using macro?

Thanks, in advance,

Deepika.