Showing results for 
Search instead for 
Did you mean: 
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!



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 :

Blog :

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

Super User
Super User


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

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)