Yesterday we heard (again) that SSAS will be supported as a data source for cloud-based reports in Power BI. Today, in a session, two new important details on this emerged:
- It will work with both Tabular and Multidimensional
- It will connect as the user running the query, so SSAS security (eg dimension security) will work just the same as it does on-premises. No special setup will be needed; there were no details apart from the fact it will work using the EffectiveUserName connection string property.
I’m sure a lot of people will be interested to hear this…
Reblogged this on George's BI Blog.
Hi Chris this is great news will it support writeback? Thanks Trish
I don’t know for sure, but I bet it won’t.
When ? When ?
I have no idea when, as yet.
This is interesting news indeed. I am wondering if it will allow drill through to be limited via the SSAS security model and would be equally interested to see if they are planning on supporting data drilltthrough to line level.
I have no idea about that, sorry…
Thanks Chris for the updates. Good to see that MS hasn’t really dumped the MD engine.
Nice. We use Tableau Online as our portal for users, Tableau for power users, and Excel/SSAS for power users too.
We can only use SQL Server (a historical flash point) for Tableau Online since we can’t get a direct connection. We have no option to export an ssas extract for Tableau. If Tableau could connect to SSAS on premise, that would be so awesome 🙂
Signed up for the preview and still can not connect to Multi-Dimensional. The site indicates only 2012 Tabular or later.
Multidimensional is definitely coming, although it too may only be 2012 or later.
Does this explain the object not set to an instance error I get when trying to connect to SSAS 2008 on premise with the updated version of Power Query?