Dataset size doubles in service after adding relationships

[Anonymous]

Hi,
My dataset size is 3.7GB without relationships but it increases to 7.2GB after adding all the relationships. The cardinality of all the relationships is many: one and the cross-filter direction is also single. We have also disabled the Auto/date time. Please suggest what changes can be done to avoid this.

[ribisht17]

@Anonymous 

There are eight different data reduction techniques covered in this article. These techniques include:

• Remove unnecessary columns
• Remove unnecessary rows
• Group by and summarize
• Optimize column data types
• Preference for custom columns
• Disable Power Query query load
• Disable auto date/time
• Switch to Mixed mode

Regards,

Ritesh

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series