Forum Discussion
Multiple data sources creating too much data
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!
2 Replies
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.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.
