SSAS Cube Connection and MS Power Query

[BI_Pleb]

Morning,

I have a need to get data out of an SSAS cube into Alteryx, to blend without data source. There does not seem to be way of doing this directly, so have created an MS Power Query in Excel (effectively a refreshable table) which I refresh prior to running my alteryx model.

Two questions:

• Does anyone know of a direct way to connect to an SSAS cube into Alteryx?
• Does anyone know how to trigger the refresh of MS Power Query in Excel as part of the Alteryx work flow?

Cheers

Dave

[s_pichaipillai]

Dave,

Please replace the MDX macro (attached) wtih the old one

and let me know if this gives a fix 

[BI_Pleb]

Getting an error that MDXResult.csv has too many fields, when i check this file it looks ok but still no text delimiter.

I've been trying to debug and believe change is required to Program.cs add text delimiter as part of output and/or make it a pipe delimiter.

Unfortunately my C coding is basic at best, so would appreciate your support :)

[s_pichaipillai]

we can fix it in Alterx. updated the macro

i think attached should work

[BI_Pleb]

Morning,

This now runs but the output is now removing the rows where value had issue e.g "North, Korea", was this what you are seeing also?

[s_pichaipillai · Accepted solution]

Hi Dave  , @nilbot

i fixed this issue . this is caused by the data comes with comma which i did not think :)

Download the updated SSAS.exe and replace with the OLD one

https://www.dropbox.com/s/rgfk4ffmhdoy0i8/SSAS.zip?dl=0 

[BI_Pleb]

 Thanks a lot for keeping going with this, the output now looks good. :)

[s_pichaipillai]

Excellent!!!

Happy Data Blending!!! :)

[nathan_fredette]

So I get the "255 Stopped Working error" as well after upgrading to Analysis Services 11 per post.  When I open the macro shows File not found error for MDXResult.csv.  I went the temp folder and I dont see the .bat or .csv file from macro. 

Thanks for any and all help!

[s_pichaipillai]

did you configure all the steps i mentioned in the 4th Reply ?

[nathan_fredette]

I selected the "Run Command", but I dont have the options that you show in the picture.