Hi All,
I am importing into dataverse a flat excel file which has hundreds of columns and i wanted to know what the correct approach to this should be? If i was importing the flat file into power BI directly i would use power query to split it into a star schema with a fact table and multiple dimensions.
In dataverse should i follow the same methodology and split it into multiple tables or is it best to leave it as one huge file and import into a single table? If anyone has any recommended links from a dataverse perspective they would be massively appreciated.
Thanks all!