Data not loading correctly from excel file sharepoint online

[rains_23]

Hi,

I am trying to connect to an excel in powerbi, using sharepoint online. I am using sharepoint folder in Get data. When I connect, I can see the list of files, but once the file is loaded, it is not showing the columns in it but something different. What am I doing wrong.

My file has this data,

However Power BI is loading 

Thanks,

Rains

[amitchandak]

@rains_23 , There is some issue with the type of connection you have taken, this is csv UI

This one should work for SharePoint too

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

[rains_23]

Yes that works, but the problem there is I would need a specific path always, and would need to create different connections for each file. Secondly the file name would need to be same always.

I was looking at populating all the excels, if that works.