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.

     

     

     

EvertonPessoa's avatar
EvertonPessoa
Helper I
9 years ago

hi Anonymous,

 

What is the origin of the base?

 

está usando uma consulta SQL?.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

yes, the data is stored in a SQL database.

I had thougt to make first for each table a view with the nessesarry data. Then is it also not required to make a mergetable in PowerBI because I can join the tables in the SQL View.

 

Where is the split to do the transaction in SQL or in PowerQuery?