Forum Discussion
Anonymous
5 years agoNot applicable
Power Query Drops Leading Zero
Dear community, Hope my message finds you well! I have 2 data sets which contain 1 fact table and 1 dimension table. Both data sets are CSV files and all columns are formatted with type "...
Jimmy801
5 years agoCommunity Champion
Hello Anonymous
do you have any chance to change the xlsx-file? If yes I would reccomend you to save them as a table in Excel and then read from this table instead of your sheet.
Hope this helps, otherwise let me know
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy