Forum Discussion

Yogisha's avatar
Yogisha
Frequent Visitor
5 years ago

Increase in PBIX File size after changing data source

Hello, Size of the PBIX file increased from 700MB to 2.2GB after pointing from SQL Server to Snowflake with the same data. Any thoughts?

Need Help

2 Replies

  • jeffshieldsdev's avatar
    jeffshieldsdev
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Difference in data type? Trailing spaces? Were columns sorted in SQL and not Snowflake? That can affect the columnar compression.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,  Yogisha 

    What connection mode are you using?

    Is there any change in the data model?

     

    Best Regards,
    Community Support Team _ Eason