Forum Discussion
Dealing with Large Datasets
Power BI Community, How do you deal with large datasets? Do you always utilize a live connection to a SSAS cube or import the data? I am at my wits end. I am attempting to figure out the best...
When possible the live connection is the better way to go. The security is inherited from the server and the model is a lot faster. If you import, the big trick is add things in steps. First pick your most restrictive or smallest filters (member filter). Generally, this would be the year column, department column, or financial statement column. Then use add items to add in your next most restrictive filter. Once all your filters are set then you add in your data. Please note, that you can add in multiple filters at once, but I generally do one at a time for performance purposes.