Forum Discussion
Global Datasets and Datasources
I would "assume" that you should be able to just publish a dataset, however in all the testing I've done with Org Content Packs it would appear you need to include at least one report and dashboard in order for it to work. If you don't include all 3, the dataset and or report show up, but the load spinner just keeps going.
So - as of right now, no you can't do this with Org Content Packs
If this is just a bug, and you should be able to just publish a dataset, then the answer changes to "yes" if you are using something like tabular models where you can control the permissions on a different level.
The person who was telling me how this can work was assuming that the Azure SQL server would be filtering the rows based on the user credentials, so that some users would see a subset of the data.
It's not clear to me how this can work; it looks to me that Power BI copies the entire dataset and so SQL server no longer has any ability to filter rows by user id.
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.
