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.
If you want to import directly you need to CREATE Table first with 100 Columns
My Suggesstion would be
Store the file in One Drive or SharePoint and Use DataFlow --> it will Create Table and Columns as well
Please mark as Answer if it is helpful and provide Kudos
Thank you for a response but I am not understanding why you would not want to normalise the data into a "proper" database structure