I extract my HubSpot data from Power BI using an API connector. HubSpot utilizes one large table to house most of their data around contacts, meaning roughly 376 columns? I don’t need all those columns obviously but in your estimation, what is the maximum # of columns a table should have before it’s best to duplicate. The maximum columns I would need is 68 out of the 376.
Your insight is appreciated.