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 201...
For now i made for all the tables i need in the Dashboard a SQL-View. So i can easily handle the input and the performance of the database / server is.
With the join in the "advanced options" the refresh time was verry long.
In Table 2 i don't have a date field.
I have to reduce my PowerBI size and also dateset.
Whats the way to go?
All you need is a join statement that will pre filter both tables, combine them and load them into Power BI. Example:
Select * from
orders
join orderlines on orders.orderid = orderlines.orderid
where orders.orderdate between '01/01/2017' and '12/31/2017'
You can replace * with specific columns that you care about. Hope this helps.