cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hitman_Hoyle
New Member

Large Flat Excel File

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!

 

 

4 REPLIES 4
rampprakash
Super User
Super User

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

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
Super User
Super User

@Hitman_Hoyle 

There is no downside to normalizing your data.

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,228)