Forum Discussion

jrop's avatar
jrop
Regular Visitor
1 year ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
Table B is written using table A in a Talend job.

Why?  Why not do that directly in SQL Server?

jrop's avatar
jrop
Regular Visitor
1 year ago

Because the idea is to be able to eliminate this Table B of the SQL Server Data Warehouse since it occupies 90% of the storage and I am trying to recreate it directly from Power Query.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    You will find that Power Query will take much longer to create Table B. Go ahead, try it out.