Import multiple files from folder new version PowerBI

[Anonymous]

Hi,

I´ve updated my PowerBI and now when I import multiple files (CSV) from folder, I have the next problem.

If I select Delimiter "semicolon", I only have one column (FECHA) and this is not correct, because I need all columns (FECHA,NAME,USER_ID....)

I must ignore the first rows of the files. The interesting data starts in the 5 row.

In version "DIC-2019" I did not had this problem. The problem occurs now when I update to the new version
https://www.microsoft.com/en-us/download/details.aspx?id=58494 

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

I'm using the latest version and the feature works fine on my side.

Since i can't repreoduce your scenario, I'd like to suggest you to check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-jayw-msft 

Now, I need import this files using import from folder to one pbix file

This pbi should have one table with this columns: FECHA,NAME,USER_ID,ASSIGNED_STORES,USER_STATUS,COUNTRY,HANDLED,CREATEDCASES,CLOSEDCASE

The problem is that one file use ";" delimiter and the other file use "," delimiter.

This is a simple example, but I need import a  lot files from one folder.

https://drive.google.com/file/d/1Stmt6VB7-WhY4j1-QvAq2QG9iD5yu2Oh/view?usp=sharing

https://drive.google.com/file/d/1CPeaMixj1imwfluJ1lHxiARI-RXYYlQA/view?usp=sharing

Thanks

[amitchandak]

@Anonymous , Now sure this issue with the new release. In this case, you should have removed the first 4 rows and made the 5th one as the header. Is that not your setting?