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