Forum Discussion
Global Datasets and Datasources
SQL Azure and SQL Analysis Services are a direct connect mode, no data is cashed in PowerBI.com, row level security certainly works with Analysis Services, but I don't think it will work with SQL Azure becuase user name and password are part of the connection information.
I'm not using SQL Analysis Services. I wonder if I need to in order to accomplish my goals? My source is claiming that there is some sort of single sign on capability that would pass through to Azure...haven't seen it yet.
My advice would be to implement Analysis Services. If you already have a power pivot model, it can be imported into Analys Services in under a minute. You do need an instance of SQL Server Analysis Services to deploy it on though.
Ultimately, Analysis Services is the way to go.
"Ultimately, Analysis Services is the way to go."
Argh. My role is data architect and I'm designing the warehouse. I didn't anticipate having to get up to speed on the BI side of things. There's more to it than I expected.
BTW, I don't actually need the environment to support row level security....I can implement that myself in a View, for instance, although I do need appropriate user identity.