Split Power BI Dataset & Report | Developer Best Practice

This video covers why you need to split your Power BI Dataset & Report. This is one of the best practices that you should follow in your Power BI development. This is also called Shared Dataset or Golden Dataset which can be used for multiple reports.

I have covered below topics.

1. Why you need to split Power BI dataset & report
2. Benefits
3. How to split the dataset report - New Projects, Production files.

Subscribe my channel for more videos.

[pcervello]

Thanks a lot! I had that exact same issue, and thanks to you, in a matter of 30' I have a single dataset and multiple reports showing from it. Thanks!

[ianmichelle]

Your video is a tad lengthy, but it's comprehensive! and covers all the aspects! loved it!

[Seth_majestus]

I cant connect PBI dataset on service. What should I do now?

[laionegan]

Very well explained.interrsting the api part to rebind the report.thx Mr Hari

[nidhisingh]

Hi Hari,
Thank you so much for this video. I have one below doubt related to live connection mode. Can you please clarify this.
We have an option to create measure in "Report view". Suppose I have created a measure and then publish the report to power bi service. How this measure get linked to dataset or where I can find this measure in power bi service?

[santoshhmt]

Hi
Can we connect to two shared datasets from a same workspace or from different workspaces and create a reports.
Please reply or make a video on this use case it helps a lot.
Thank you.

[paulgallagher]

I find it's often the case where we'll have one "Master Report", in the case it would be the Sales Dashboard. Then multiple smaller specialist reports, eg "Sales by Product" in your example.

Because of the difficulties associated with modifying and improving an existing report/dataset that is split across 2 pbix files, would you see any reason why we shouldn't have our "Master Report" as 1 unified pbix file and then any other specialist reports just connect to the master report dataset?

[joaorataoo]

For me the main problem when we connect to the dataset is that we no longer have the table mode available in Power BI Desktop.
Thank you for your explanation.

[winnieleung]

Hi Hari, Thanks for your video! I have 1 question on how to best modify this dataset afterwards, as the original report is deleted. Do you always save a .pbix file with the original report somewhere locally/online just to be able to open or modify this dataset? Or could you actually directly download the datamodel and modify from there?

[mirrrvelll]

Great video man! You got one more follower for this! This will be useful!

Do you have some videos with power automate and extracting groups + members from admin portal?

[kristinamelnichenko]

Great explanation of why you would want to separate data and report, and showing how to. Thank you!!