Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kevint13
Regular Visitor

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) :

temp.jpg

Format applied to the file (locally) :

temp.png

Format from Query Editor (local) :

temp (1).jpg

Import side via SharePoint :

temp (1).png

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

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-xicai
Community Support
Community Support

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.