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...
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.
I probably need to educate myself on what Analysis Service provides; perhaps it would make it easier for end users to understand and use the data, which has been a concern.
Thanks for your input.