Ability to share datasets or connection to other users.
Ability to share Dataset and connectivity to other users
We released the Shared and Certified Datasets feature which addresses this need. You can now discover the datasets to which you have permission using the new discovery dialog in Desktop and the service. Then you can save your report in a workspace. To save to a different workspace, you need to use the a new workspace experience workspace.
I have an issue that I hope someone can help with. I have a dataset that is shared with multiple people. When people try to refresh that did not create the dataset, but it was shared with them, there is no error but it does not refresh. How an I fix this?
Daniel Valle commented
I read that Microsoft plan to deprecate organizational content packs soon and replace by apps. So when the dataset connection in the apps will be available ? Today, in the apps it's only possible to use "Analyse in Excel" but we also need to be able to connect from Power BI Desktop or copy/link the dataset into personal workspace. Thanks.
Santiago Martínez commented
+1 for adding this feature
jerry deng commented
Our way of re-using one golden dataset across different apps is following, as I commented on one of Matt Arlington's blogs:
In my scenario I am making this Golden Dataset available to use in multiple App Workspaces, to maximize the application of “single source of truth”. This is done by using Sharepoint to house the Golden Dataset (PBIX), then in each of the App Workspaces use Get Data –> Get Files –> Sharepoint Teamsites, then point to where the PBIX file is uploaded.
The setup is pretty straightforward, using Sharepoint as the cloud storage for PBIX files, and by using the "Get Files from Sharepoint" method above, in each App Workspace, the Golden Dataset is now available for use in each App Workspace, and subsequently production Apps. Future updates in the Golden Dataset (data refresh, measures, relationships) will reflect to each App Workspace.
Of course this doesn't address the need to connect multiple datasets in one report, that remains on the wishlist. Also this is somewhat convoluted to implement.
We are also looking for the data set sharing. The steps provided by Admin is looks good for the one time sharing. But we have field analytics people who want to use the data sets created by BI developers. These sets refresh daily but analyst can't use it because the sharing is one time and don't refresh once the central (original) data set get refreshed.
This will be the key feature we are looking for right now for our internal analysts.
Dennis Bybæk commented
1. we have +30 customers running a web based system (one per customer), each having their own database.
2. we want to give all our customers the ability to create reports in Power BI, were we create a Customer-workspace per customer... so +30 workspaces.
3. we will create a dataset that our customers can use to create report on... but so far, we will need to have a dataset inside each customer-workgroup. So +30 identical datasets, connected to their own database through Gateway connection.
4. Then we need to make a change or add more to the dataset... so we do this +30 times..... and maybe when we are done, we see that we forgot one little thing (we are only human) so we do it all over again... :-(
I get tired of just thinking about it
So our wish is to have one dataset, that multiple Workgroups can use for multiple reports... AND be hooked up to their own database (we use Gateway connections, where we have one on-premises gateway that have access to multiple database servers that have all the +30 databases)
I don't think this will be possible... ever!... and our customers are asking more and more about the possibility of analyzing one their own data... well it possible but a hell to maintain.
Another thing while I'm at it... many of our customer already have a Power BI Pro licens... great, but does not matter, because it cannot be used/reused in our Power BI... so they need to have two Power BI Pro licens, one for their own Power BI and one for our Power BI... great thinking Microsoft!
Yes, the biggest gap with shared dataset today is, users can just only have to build reports with the tables available in the dataset. But if users want to add more tables and join them with shared tables and build reports. This is not possible. This is actually limiting lot of capabilities in the enterprise. For example i want to share the dataset which make sense for the users and let them add their own tables in addition to the data i share and build from there. Since this is not possible today, we end up sharing the source directly which is seriously a gap in Power BI.
John Genske commented
Yes a stale content pack is not a solution. When you create a gateway data source you should especially be able to share it.
I can't expect end users to get the right voodoo combination to a Enterprise gateway data source.
I can share this in a workspace and they can choose it in a report, but then they can't do getdata with any other data, maybe they want to join it to something else, or have multiple shared data in one project.
They may also want to add their own custom columns for transformations on top of the source data, or save it in a workspace outside of the data set.
I could be off base, but don't think I'm alone.
I'd like to share the original dataset that is refreshed and the end user can add custom columns and whatever they want, just like any other data source. Instead workspace online data sources become a stand alone siloed tabular data set, which is the opposite of this tools potential.
Neil Palmer commented
I'd like to be able to share a dataset so that end users can do self-service if they wish. Keeping any updates centrally managed.
Currently "Apps" do not support sharing a dataset, so content packs remain the better model as they can do this and do not require creating lots of groups.
Kayleigh Happersett commented
I hope this is addressed. I want to share a dataset with users so they can create custom reports, but have everything updated when the original dataset is refreshed. Content packs and apps seem useless as they won't refresh with the underlying dataset....
Andrew T. commented
Also, Apps now supplant Content Packs. So what's the alternative now?
I'm agree, "make a copy" is useless. You need to share the original dataset so that any subsequent changes are available to other users, as admin. you can be sure data is ok and updated.
Hi, I like this idea but I want to share the dataset to a PowerBI Pro user who is outside my organisation. This would make sharing data sources so much easier as I wouldn't have to configure VPN's and Firewalls to give our business partners access to their data. Ideally the user could access this dataset from PowerBI desktop. Should I create this as a separate enhancement request?
Peter Hind commented
Not being able to share a dataset is crazy.
The content pack alternative looked promising if you could atleast create a report off the original dataset.... Having to make a copy makes no sense at all.
This request has been open for more than 2 years. Monthly update, upon update occurs yet something as critical and more to the point something that should be standard is ignored.
Jesper Sommer commented
I need an ability to assign additional administrators to the dataset I am sharing, when using RLS (Row Level Security). I have 200+ users viewing data through RLS, and as the owner of the dataset I can see "everything". But we are 3 report builders, so I need some kind of ability to share the "everything/owner" view, that doesn't require me to hack the RLS logic.
ajil jins commented
At organisation level anyone can access the content pack. How do I share a dataset to specific user group (without adding/creating a work space ) ?
At the moment I face huge huge problems goin from SQL Reporting Services to Power BI. I have to maintain 2 Reporting Platforms, ok in the future there will be a chance, but Power BI destroys my logical sense of infrastructure and a clean up workspace when I can't share DataSets an need to make a copy out of a published Content Pack.
And last but not least..really stable and a quick response I only get with the Data Gateway and Direct Query to my ReportServer Database. When u use official Content Packs from MS (Dynamics) oder Salesforce..they are not really usable, maybe on the desktop version, but from smartphones a simple 1000 rows dataset loaded nearly a hour.
Andrew T. commented
FWIW, most of my clients adopting Power BI think this is already how it works. The fact that it doesn't, and that you have to do the oddball Content Pack copy trick do build reports from a shared dataset, is a rude surprise for many.
Ryan Emptage commented
Allow the user of the shared dataset to manually refresh it.
Hi. Once you have shared the dataset is it static or will it update if the original user updates their dataset?