Forum Discussion
Reduce data
Hi,
I have the folowing situation
Table 1= Orders (400.000 rows)
Table 2 = Orderlines (1.500.00 rows)
Step 1. Get the data into PowerBI
Step 2. Filter table 1 (orders) for only year 2017
Step 3. Merge this 2 tables on the field orderID
Result:
With the merge table i have a dataset with orders and orderlines that i need filtered on year 2017.
Table 1 (orders) is reduced with the date field, so this not too big
But table 2 (orderlines) loads all the original data so the PowerBI file is verry large.
How can i reduce my PowerBI file or table orderlines?
With kind regard
Norbertus
10 Replies
hi Anonymous,
What is the origin of the base?
está usando uma consulta SQL?.
When you get the data you can put a SQL command instead of selecting the table in the structure. In this command you can add the filter to 2017 in the WHERE clause if this is the case:
Interesting, I would think the performance should be similar. There are definitely benefits to having a view, but essentially you are still executing the same query when you select data from a view. But if this approach gives you shorter refresh times, then you are good to go. Be sure to mark this thread as resolved.
