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 responses

  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. Pingback: BPOTW 2014-11-07 | SQL Notes From The Underground

  3. Pingback: Datamaze – Letture per il fine settimana (2014-11-07)

  4. 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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: