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

Dataset organizzation

Hi,

Inexperienced, I have created a series of reports on different datasets which, however, are fed by the same tables.

This is wasteful, n datasets, containing roughly the same data, are updated overnight.

My idea was therefore to create one big dataset connected to many small reports.

That would also make it easier to manage dataset rules.

The problem is that since the dataset is very large, some measures that generally worked now give the following error: “This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed. Please try again later or contact support. If you contact support, please provide these details.

Is there a way to across this problem?

Reports are very simple; I think that most resources are impregnated by the dataset although each report uses a small part of it.

How can I solve the problem?

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @lfrigione ,

 

Based on what I have learned, there're two methods for your reference.

 

1.With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. For more information, please refer to Create report templates for Power BI Desktop.

 

2.You can publish your pbix file to Power BI service, then use the dataset in Power BI service with live connection mode to create your new report. For more information, please refer to Create reports based on datasets from different workspaces.

 

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @lfrigione ,


Sorry to disturb you...


But did I answer your question ? Please mark my reply as solution. Thank you very much.

v-stephen-msft
Community Support
Community Support

Hi @lfrigione ,

 

Based on what I have learned, there're two methods for your reference.

 

1.With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. For more information, please refer to Create report templates for Power BI Desktop.

 

2.You can publish your pbix file to Power BI service, then use the dataset in Power BI service with live connection mode to create your new report. For more information, please refer to Create reports based on datasets from different workspaces.

 

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

amitchandak
Super User
Super User

@lfrigione , You should always prefer a start schema. https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

 

For the issue refer if this can help : https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors