cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BigLo
Helper II
Helper II

Multiple DashBoard based on the same dataset

Hi,

 

I've several Dashboards but the data model is the same. (data sources, data model, measures, added calculated columns, ...) and it  evolve frequently.

 

What is the best way (clean and easy to maintain) to manage this?

 

Create a DashBoard to generate a dataset and have this dataset as a source for my 'visualizations-DashBoard'? But then, I have to modify and then publish my 'Dataset-DashBoard' every time I make a modification in my model to update the dataset?

 

Is there a better way?

1 ACCEPTED SOLUTION
Sumanth_23
Super User II
Super User II

hi @BigLo - Yes, the most optimal approach would be: 

Step 1: To create a Dataset file and publish the same to Power BI Service. 

Step 2: Following this you can use Power BI Datasets as a source and connect to the dataset published as part of Step 1

Sumanth_23_0-1619987851168.png

Step 3: Any further model changes - table, measures, calculations will have to be made in the dataset created as part of Step 1

Step 4: All reports connecting to this dataset will automatically see the changes to the underlying dataset - no additional changes / updates are required in the reports 

 

Do vote/mark this post as a solution and provide kudos if it helped you with your question. This would also help others on the community who may have similar questions. Thanks!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
v-yangliu-msft
Community Support
Community Support

Hi  @BigLo  ,

You can go to configure the scheduled refresh. After the specified time, the data set will be refreshed without changing the name of the data set

v-yangliu-msft_0-1620197675350.png

For related documents, you can check this link:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sumanth_23
Super User II
Super User II

hi @BigLo - Yes, the most optimal approach would be: 

Step 1: To create a Dataset file and publish the same to Power BI Service. 

Step 2: Following this you can use Power BI Datasets as a source and connect to the dataset published as part of Step 1

Sumanth_23_0-1619987851168.png

Step 3: Any further model changes - table, measures, calculations will have to be made in the dataset created as part of Step 1

Step 4: All reports connecting to this dataset will automatically see the changes to the underlying dataset - no additional changes / updates are required in the reports 

 

Do vote/mark this post as a solution and provide kudos if it helped you with your question. This would also help others on the community who may have similar questions. Thanks!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

Dnerada
Post Patron
Post Patron

Hi @BigLo 

 

that is the best way. 

See the link below it is a great representation of how and why. 
https://m.youtube.com/watch?v=PlrtBm9YN_Q

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors