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

No video

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

Рет қаралды 19,800

Күн бұрын

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:
radacad.com/po...
*******************
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.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad....
Free books and tools for Power BI: radacad.com
Power BI Helper: powerbihelper....
Become an academy member: learn.radacad....
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

Пікірлер: 32

@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

@Wzxxx 11 ай бұрын

Thank You so much! So well explained.

@Adeelkhalid17 Жыл бұрын

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

@tatsianastarastsenka6251 Жыл бұрын

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

@assaff100 Жыл бұрын

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

@santoshhiremath-kl9nu 6 ай бұрын

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.

@jaanaan2847 5 ай бұрын

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?

@nicolaslupo5021 Жыл бұрын

Great content! Cheers from Argentina!

@RADACAD Жыл бұрын

Awesome, thank you!

@candassaldroglu3645 6 ай бұрын

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

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

@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?

@jgowrri Жыл бұрын

Thank you. What is your recommendation towards versioning?

@schattedaenker Жыл бұрын

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

@RADACAD Жыл бұрын

You're welcome!

@wowrb 2 жыл бұрын

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

@ruchitagupta1549 10 ай бұрын

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.

@mojgantaheri6456 Жыл бұрын

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?

@Wzxxx 11 ай бұрын

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

@dhavalthumar6720 10 ай бұрын

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?

@mohamedmabchour6759 Жыл бұрын

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?

@hklee4441 2 жыл бұрын

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

@RADACAD 2 жыл бұрын

yes, you can. but it won't be called live connection anymore. It means creating composite model with DirectQuery to the Power BI dataset. and it works very nice actually. highly recommended to check it. I have other videos about it.

@willianranzani1223 Жыл бұрын

Nice explanation!!

@visheshjjain 2 жыл бұрын

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

@RADACAD 2 жыл бұрын

Those who have Build/View access to your dataset, can use it in any workspaces that they have access to. if you want to limit that, limit the access to the dataset to only people who won't use it in other workspaces

@jyotijaiswal4784 Жыл бұрын

Can we transform power bi dataset

@FedericoLov 2 жыл бұрын

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

@RADACAD 2 жыл бұрын

As mentioned in the blog already. When you publish PBIX from the desktop, the report is always published with the dataset. You can remove it after publishing, but the next publish will publish it again. So short answer; using Power BI Desktop, no. but the workaround is to remove it after publishing.

@davidlopez-fe2lb 2 жыл бұрын

@@RADACAD Yup, this is what I do. It'll always publish both dataset & report, although my "report" is just the data model and I don't want anyone to see/use it, so I just publish any updates then remove the data model "report" and then just the shared data set lives in the workspace for usage.

@pjosifovic Жыл бұрын

@@davidlopez-fe2lb Do you recommend this approach for providing datasets to multiple users?

@davidlopez-fe2lb Жыл бұрын

@@pjosifovic you could do that if you are at an enterprise level and are responsible for managing all those assets. We have one "golden dataset" that has 99% of the data we need, there will always be some flat file floating out there that we'll need, and we give access to all our department teams and we use ourself.