News On SSAS Data Source Support In Power BI

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…

14 thoughts on “News On SSAS Data Source Support In Power BI

  1. 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.

  2. 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 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s