Import from SSAS using custom DAX query

(added by @dgudkov): the topic is split from: Import Power BI Dataset [DONE] - #4 by dgudkov


Hi,

Is it working on live connection dataset ? I mean can you import a Power BI dataset with a SSAS cube as datasource ? Because this would be a way for Easymorph to query a SSAS cube, using Power BI technology.

But if you are able to send DAX query to Power BI, I guess you would be able to do the same to SSAS tabular model cubes ? In companies, SSAS cubes can be a way to expose data, a bit like Business Objects universes. So it's nice if Easymorph can manipulate that.

To be honest, I don't know, we didn't try that.

Technically, sending a query to SSAS isn't hard. Making the Visual Query Editor work with SSAS is more challenging. Would sending a custom DAX query to SSAS work for you, or do you need SSAS supported in the Visual Query Builder?

Just found this topic. Sending a DAX query to SSAS is all I would be looking for. I use this type of query all the time to render tables in Excel. Would be wonderful if I could do the same in EasyMorph. DAX Studio (https:/daxstudio.org) has a visual query builder so I see no reason for you to include that in EasyMorph. Thanks!

Hi John and welcome to the Community!

I moved your reply to a new topic in Feature requests. Now that we see that more people ask for this feature, we will evaluate what it might take to add it.