Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

     
    Unfortunately wasn't it posible to do it in PowerBI.

    With the join in the "advanced options" the refresh time was verry long.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

 
Unfortunately wasn't it posible to do it in PowerBI.

With the join in the "advanced options" the refresh time was verry long.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.