Use SHARED DATASETS to collaborate easier + best practices // Beginners Guide to Power BI in 2021

[@lijunchen]

This is a great way to collaborate with others. Thanks.

[@sonjoysengupto]

Fernan, can we share measures and calculation groups in one model with another model?

[@eleftheriakoniari3392]

Hi!Thank for all your videos! Can I create a new power bi report using a shared dataset and apply row level security only for this report and not to all the reports using this dataset?

[@vinayv1123]

Your videos always solves my issues.

[@SenthilKumar-vu7mf]

Thanks! Very useful video. Appreciate for that. 1. Can we use direct query dataset and composite dataset as shared dataset? 2. Can we add measures at report level while using the shared dataset? 3. Can we combine two shared dataset and use it in the same report?

[@bobhatter94]

Very professional. Best presentation of this subject yet. keep it up.

[@SolutionsAbroad]

Thanks for the compliments!

[@oladman9058]

I like to say a big thank you for a job well done. I finally nailed the connection between datasets and reports.

[@SolutionsAbroad]

you're welcome, thanks for watching!

[@paulmcnally4994]

Hi , i hwve 4 pbix reports and the data spurces are differnt. I want to bring these data sets into one report, and build a new report. Is it just thebprocess of using the existing PBIX files data sets? Sorrybik new to Power Bi

[@jjenabh]

Hi, we are using live connection to shared dataset. i need to change a table name on shared dataset. how to addreess this ?

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

[@prakashgadupoodi7549]

Thanks a lot Fernan. Just subscribed. Looking forward for new uploads.

[@santoshhiremath-kl9nu]

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.

[@dhavalthumar6720]

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?

[@CaraG86]

GREAT info! Thank you for sharing!

[@POng-lq6yj]

Thank you so much. It helped me a lot

[@kingsfordgokah6240]

This is great, thanks Fernan

[@juansolares7198]

Hello. I have a shared dataset and other users have created their own reports with my dataset. How can I find the report name and the user that created the reports?

[@SolutionsAbroad]

Hi Juan, you can check the lineage view in your sharepoint to see what other reports are connecting to your dataset, along with their owners

[@emilymalkin270]

Thank you!

[@vanishedxu]

I really love the idea of shared datasets. But most of the time, the shared dataset doesn't have everything a new report needs, and there's no way to add an extra data source. Also, the fact you cannot see the data itself as a table is quiet annoying. What's your though about these two issues?

[@SolutionsAbroad]

Hey Van, great point, and indeed shared datasets have this problem, because its a live connection to the shared dataset. Typically if I want to have an extra data source, I choose to use a dataflow which gets around this problem; dataflows are treated as separate data sources within the dataset Recently the PBI team released a way to connect to datasets, called Direct Query for PBI datasets and Azure Analysis Services, that allows you to import the data into the local model, as opposed to just a directquery, docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services Regarding my preference, it would be dataflows, just because its easier to manage and cleaner to reuse, but both are valid options

[@raviranjansingh5527]

Thank🙏 Sir

[@SolutionsAbroad]

You're welcome!