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.

Thanks. You may wonder why an extraction tool would plug to SSAS as SSAS can be seen as a tool related to final vizualisation, not big export. SSAS has another advantage : it contains a data model, it's an alternative to Business Objects universes for example. In this case you may want to extract data from SSAS and taking benefit of this data model that brings data coming from different tables together. Extracting data from PBI dataset with DAX is an interesting option but in the case where your data is VERY sensitive, you don't want to expose your data on the internet. In this case SSAS remains a good option.