Large Flat Excel File

[Hitman_Hoyle]

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!

[rampprakash]

Hi @Hitman_Hoyle 

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

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

[Hitman_Hoyle]

Thank you for a response but I am not understanding why you would not want to normalise the data into a "proper" database structure

[Drrickryp]

@Hitman_Hoyle 

There is no downside to normalizing your data.

[Hitman_Hoyle]

@Drrickryp Thanks. A few articles have said otherwise but good to hear arguments in favour of...