Forum Discussion
Power BI Report Size Increase with Different Queries Despite Having the Same Amount of Data
Hello all, I am in a data project with several reports. In some of them, I use a 'TableA' stored in a SQL Server Data Warehouse. On the other hand, I have another table 'TableB', which is create...
Yes, I currently have both table A and table B in SQL Server. These are written daily with a Talend process.
Table B is written using table A in a Talend job. The idea is just to be able to eliminate Table B from the Data Warehouse and the Talend job since they take up 90% of the storage in the Data Warehouse and a part of all the time of the ETL process.
That is why I have tried to replicate this job but in PowerQuery with the long query making use of table A directly. In the end, the resulting number of rows and columns is the same, but the file size is much larger, and I don't know the exact reason for this.
lbendlin
Super User
Super UserTable B is written using table A in a Talend job. Why? Why not do that directly in SQL Server?