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…
Categories: BI, Power Query, SQL Analysis Services
BI, Power Query, SSAS
Comments (0)
Trackbacks (0)
Leave a comment
Trackback