cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Greg_Esres Regular Visitor
Regular Visitor

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 possible in Power BI, but I haven't seen yet any features that provides these capabilities. Power BI seems geared mainly towards sharing spreadsheets in a peer-to-peer manner. Can someone point me in the right direction?

16 REPLIES 16
andre
Advisor

Re: Global Datasets and Datasources

You can create a content pack with a data set only (no dashboards and reports).

 

Here is how:

 

http://businessintelligist.com/2015/07/21/content-packs-can-now-be-created-in-powerbi-com/

Greg_Esres Regular Visitor
Regular Visitor

Re: Global Datasets and Datasources

That looks promising...thanks!

Super User
Super User

Re: 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.


Near SE WI? Join our PUG Milwaukee Brew City PUG
andre
Advisor

Re: Global Datasets and Datasources

I just published a content pack with a data set only and was able to connecto to it, not sure why it does not work for you.  I would say the answer is Yes

Greg_Esres Regular Visitor
Regular Visitor

Re: Global Datasets and Datasources

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.

 

 

andre
Advisor

Re: 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.

Greg_Esres Regular Visitor
Regular Visitor

Re: Global Datasets and Datasources

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.

andre
Advisor

Re: Global Datasets and Datasources

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.

Greg_Esres Regular Visitor
Regular Visitor

Re: Global Datasets and Datasources

"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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 283 members 3,001 guests
Please welcome our newest community members: