Power BI Shared Datasets: What is it, How does it work, and Why should you care?

Have you ever had a situation where you want to re-use part of the model in another report? Imagine two report visualizers in your team who want to create Power BI report visualizations from your data model. You have already done some modeling and calculations. How can this be done the best way without a high maintenance cost? The answer is a shared dataset in Power BI. In this article, you will learn about:

What is a shared dataset in Power BI?
How can the shared dataset help in Power BI development?
Where is the place of the Shared dataset in the Power BI architecture?
How does the shared dataset work behind the scene in the Power BI service?
What are Certified and Promoted Datasets?

Read my blog article to learn more:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[SranioDrljaca]

We use it in OMV for empowerment: Data Engineers are creating Data Sets, and any employee can create his own report.
Additionally if employee enables "DirectQuery for PBI datasets and AS", he/she can add additional tables in the model

[tatsianastarastsenka]

Thank you for the video. It's very useful. What about performance of the report with the shared dataset?

[assaff]

Thanks, excellnt content.
A follwup video on authrization and multi-tenant might have value

[jgowrri]

Thank you. What is your recommendation towards versioning?

[schattedaenker]

Man, u are awesome. Thanks so much, this was exactly what I needed😁

[jjenabh]

Thnaksforyour video.
I have around 20 tables .. all are linked. few reports use 6 tables, and few are 10 and few are 15 . in share dataset, all reports are unnecessary see the tables.

Suppose I’ve to use only two tables on a report. I believe it will make unnecessary slow the data query. do you have any thought on this
1) I'm not able to add any additional query or dataflow or table, when i'm using share data set. is theer any way?

[wowrb]

What is a chaint dataset? I really would love to know how you can get data from (maybe multiple) datasets and then still be able to model and transform

[mohamedmabchour]

Hi

Great video!

I have one question though, how can I change a dataset for an EXISTING PBI report?

The thing is that I created a PBIX file composed of 32 pages which I split when I finished my development into 8 dashboards of 4 pages each, however couldn't change their data source to one dataset instead of 8 identical datasets, is that possible to do in Power BI Pro?

[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

[mojgantaheri]

Hi It was great, actually I used the share dataset in one big model. But I have a problem with speed. The matrix for data come directly from power BI service is very slow. Can u know the reason?

[santoshhiremath-klnu]

Hi I have 4 different shared datasets dataset 1, 2, 3 and 4. On dataset 3 RLS is applied. Imported these all and built report. Report is embedded in application. Working on PBI service but in application not opening. Please can you help me on this problem. Using SQL server for data source.

[diegomsg]

Can I have shared datasets in on premise report server? The company I work doesn't allow on cloud data.
A video about how or alternatives would be nice.

[candassaldroglu]

direct query to the power BI dataset ( 6:51 ) is there any videos about it?

[Wzxxx]

Is it possible to make and dataflows on premium workspace (as in most situations pro license doesn’t allow some calculations) then use it on pro workspace in a report which will be shared with other pro users? Or all need premium?
I have some many queries on my desktops so i would like to move and split them into data flows. No if this is a good idea. Much easier to identify error when refreshing

[jaanaan]

Hello, I'm looking for a way to share just one tab/page of a report on the Power BI web with some people. I have 20 pages and I don't want to share all pages with them. Is there a way to do that?

[ruchitagupta]

Hi. I am using a shared dataset. When I am trying to embed the report in a web application, it is giving Bad Request. Do we need to set any permissions for that? However another report in the same workspace with its own dataset is getting embedded properly.

[dhavalthumar]

Hello Sir, I've created a report using Shared dataset. The report using some additional datasources as well. So Power BI created another dataset when I publish the report. Now the developer of original shared dataset added few more fields but those new fields not visible in my report even after refresh. Any suggestion what should I do?

[hklee]

Get video. Is that possible to also build a report with more than 1 share dataset?

[visheshjjain]

Is there any way to stop sharing of datasets between workspaces? Thank you!

[FedericoLov]

Ok but can I create a dataset without a report attached to it?