Unanswered

Large Flat Excel File

(0) Share

Report

Posted on by 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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hitman_Hoyle 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Hitman_Hoyle

There is no downside to normalizing your data.

Was this reply helpful? Yes No
Hitman_Hoyle 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No