Forum Discussion
New data file failing in query import
I am self taught and do not have a coding background. I generally get Power BI, but I have a hard time wrapping my head around Power Query. I have a folder where I drop in monthly data. The last ...
Thanks - I do find the multiple queries confusing so I will try this. Since I'll have to be rewriting things anyway, do you recommend switching the file imports from .xlsx to .csv at the same time? I have the ability to export as .csv but had been using .xlsx since easier for me to open the files and double-check things in them.
vojtechsima
Super User
Super UserHey, jillmhendrix, it depends on the size of your data, but it doesn't really matter.
CSVs are more universal; I would stick with them, but if you have already .xlsx, it's okay.