Forum Discussion
Global Datasets and Datasources
I want to define datasources and datasets globally and have them available to all users when the log into Power BI. I also want to have the visibility determined by user id. I've been told this is...
"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.
Well, one could argue that data warehouse is not complete without a semantic model, which is what Analysis Services is. Your end users will most likely need data enhanced with calculations (Variance, Year to Date, etc.) so it is always good to think of it as a complete solution and not just data alone.
I would need to test it but I believe that identity is not passed to SQL Server databases (Azure or not), only to Analysis Services.