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
Icon for Helper I rankHelper 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?

     

    • EvertonPessoa's avatar
      EvertonPessoa
      Icon for Helper I rankHelper I
      9 years ago

      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:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi,

         

        Is it also possible to place in this "advanced option" a SQL statement with a join to my orders table so i can filter on the field date?

        My table "orderlines" has to be reduced with the filter year in the table "orders"