Import TXT (CSV) from Sharepoint

[kevint13]

Hello everyone,
I'm trying to import a text file from a Sharepoint by applying the same formatting as if it was imported locally, namely :

Import format (local) :

Format applied to the file (locally) :

Format from Query Editor (local) :

Import side via SharePoint :

All the data is in column 1 and I can not create the table ...
Do you have an idea ?
Thanks for your help,

[v-xicai · Accepted solution]

Hi @kevint13 ,

Here is an article about how to loading Excel/CSV Files from Sharepoint in Power BI Desktop for your reference.

You can also refer to the similar case : Connecting PowerBI to a SharePoint Folder.

Best Regards,

Amy

Community Support Team _ Amy

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