Shared & Certified datasets in Power BI

Let's take a look at the new shared and certified datasets feature in Power BI Desktop and the Power BI service. This opens up a lot of possibilities and helps to reduce data silos.

********
LET'S CONNECT!
********

***Gear***

[sweydert]

One of those videos that literally answers precisely what you want to know. Just outstanding in both content and production quality. Wow.

[arthurcsp]

That's just gold.
Thanks for the video, Adam.

[billcoleman]

Would love to see shared datasets integrated with deployment piplines in premium capacities - so dev/test/prod report collections in various workspace "triads" automatically connect to the corresponding dev/test/prod dataset version in the supporting dataset-carrying master workspaces. Currently using pipelines but manually maintaining versioning across deployment versions and workspaces.

[samuelmanseau]

Thanks a lot ! Have you plan to details the Roles 5Row Level Security) between Shared DataSet ? Is there any Apps to centralize or manage the who get access to what and where ?

[trevormay]

Does anyone have this working well in combination with deployment pipelines? I need a report connecting to a shared dataset to change connection across the pipeline, as well as report authors need to be able to change connection to the dataset in the dev workspace during the development phase.

[JamesManjackalMSFS]

In my organization we use Teams to share Datasets. In Power Bi, with the web connector, I can "get data" from these shared Datasets which at the end are in SharePoint365. So, I believe that SharePoint offers the same functional capabilities than these Datasets from the point of view of a Power Bi user. Am i wrong? Do I miss anything?

[rsd]

Hello All-Wise Guy-in-a-Cube! I have a question maybe you can advise on. I have an Office 365 organization. Is it possible to programmatically deploy pre-formatted Power BI reports for different departments without having me create them all manually? In my case I want to pull data from our financial system that shows updated budgets for each department (what they spent, how much left, etc.) and drop them into “budget” dashboards that only that department manager can see. I know I can get the data but not sure if I could dump it into a Power BI “API” in Office 365? And even if I could I’m not sure where the reports would show up? I would like each manager to go into Office 365, open Power BI and automatically see that report/dashboard. Any suggestions on if and how to do this?

[shwetkumar]

How you have shared the dataset from one workspace to another?
I will have to publish it from the desktop to that specific workspace but will publish both the dataset and report will be published?

[danningkong]

Does shared dataset have any performance catch? Say if you have a complex data model and fairly large amount of users and even considerable number of reports hanging on the dataset. Does that lock data elements when processing a query like database?

[jrbrosius]

Thanks for this video.. super helpful.. I was struggling to figure out why I could not "share" a dataset.. and closer to the end you talked about the fact that the workspace needs too be a NEW workspace... Is there a way to "tell" that a workspace is in the New mode or old? and can the old be converted to a new?

[dylanaccorti]

Super Helpful video! Just curious, are we able to build a Dataflow based on a certified dataset from Power BI?

[ZappPSR]

Do you remember that I tweeted this icon that appeared randomly in on of my workspaces long before it was announced? The one of the new shared datasets...

[tintin]

Bonjour, thank you for all these videos. I have a question concerning datasets. Is it possible to combine 2 data sets that has been shared with me ? Let me explain ... in my company Business A is connected to several files and months after months they build their data model and produced nice Power BI dashboards. Same for Business B ... I now have access to Datasets A & B, Reports A& B ... I do not want to create new visuals from reports A & B ... I wish to build report connecting to datasets A & B ... I wish to be able to connect the 2 datasets via a combine model defining the connexion ... is it possible ?

[kalpeshmehta]

Hi Adam & Patrick.. I am looking for a way to apply query merges and transformations on my shared datasets, building relationships between two or more shared datasets and so on... for a specific report. Do you already have a video on that? If so, can you please help me with the link.. Couldnt find any help around that yet. If it's not already out, it will be extremely helpful, if you can make one!

[didierterrien]

Hi Adam,
Thanks for the video. Is the dataset still certified after the owner modified a certified dataset?
Chears

[Adeelkhalid]

I have a dataset that is consumed by multiple reports. Now I am adding data from last 20 years to same data set but existing reports should only use last n number of years. Is there a way to filter last n years when connecting to shared dataset or my only option is to apply report filter on all reports

[scottpowell]

Hi Adam, at about 5:45 in this video, you caution that there are "limits on the number of workspaces that can be created". Do you have any link that calls out how many workspaces will "break" the Power BI Service?Because we have no way to secure individual reports within an app - we're going to end up with one app per report...which will be thousands of apps (and therefore thousands of workspaces). Now I'm really paranoid....Thanks, Scott

[OlivierTravers]

In Power BI Desktop, when you create a Live Connection report from a dataset in Workspace A, are you supposed to then be able to publish the report to Workspace B? I tried to but I only see the source workspace as a publishing destination (I do have admin access to other app workspaces) so I'm confused about how to complete the cross-workspace publishing process.

[GeorgEberle]

Great video. This feature gives a lot more flexibility in AppDesign. But what about shared reports?

[michaels]

Hello,
When I view my DataSet it looks like a report How do I get the compact view.

Also after I have published a DataSet what is the best way to change the DataSet? I assume I have to use PowerBI Desktop.

Thanks,

Michael