Forum Discussion
Reduce data
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.
hi Anonymous,
What is the origin of the base?
está usando uma consulta SQL?.
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?
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:
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"
You can do this through SQL if your goal is to reduce the amount of data to make the file lighter. If you do this inside Power BI, it will work but it will not reduce the file size. Your SQL will look something like this:
SELECT * FROM table2 WHERE table2.Year = (select DISTINCT Year FROM table1)