Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Import TXT (CSV) from Sharepoint

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,

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    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.

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    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.