Load a sample of data rather than the whole thing

[itsmartus]

Loading data from a tabular model (Adventure works) into the designer takes ages. approx. 30 minutes for 500.000 records. That should be faster, Probably add the option to not load all records of the fact table to build your reports.

[nishalit]

This is already the case for Import scenarios - Data in the Query Editor is only a subset (i.e. top 200 rows) of your tables. When loading to the Data Model, the full table results are loaded. Particularly for Analysis Services (as well as a few other sources), you can also use Live/DirectQuery mode, which will allow you to create reports without having to import data into the local model.

[michael_pointea]

Yes we don't want all the data being loaded, especially when large db or tables before being able to model it or create reports.

[FortnerJonathan]

I did work on this some. You have to click the Edit link after you select the tables, then it gives you a chance to filter it appropriately. It wasn't obvious in the interface when creating a new data source by selecting tables. Perhaps it would be better if it went to Edit mode by default instead of loading it all be default.