Multiple data sources creating too much data

[StaceyGriffeth]

I am trying to create a dataset using 5 tables from each of 10 SQL databases and 5 tables from each of 6 hosted SQL servers (web connector).  I am running into a load issue because I believe it is too much data.  I thought of setting up each database (5 tables) as it's own dataset .pbix, but I need to be able to combine the data for reports.  This is financial data for a series of subsidiaries which needs to be aggregated into financial statements at two levels, parent company and top-level.  Suggestions?

Thanks!

[v-alq-msft]

Hi, @StaceyGriffeth 

I'd like to suggest you refer to the document  about optimizations guide for Power BI.

Best Regards

Allan

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

[Greg_Deckler]

@StaceyGriffeth - How much data are we talking about? 

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.