cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UCiccola Frequent Visitor
Frequent Visitor

Connect to excel files on sharepoint

Hi,

 

I im trying to conect to excel files on sharepoint and i got the following error:
Captura.PNG

 

The thing is that when i try with pdf extension or csv there is no problem. The problem is with excel files.
Can anyone help me?


Thannks

5 REPLIES 5
AClerk New Contributor
New Contributor

Re: Connect to excel files on sharepoint

Hi @UCiccola 

Please provide all steps applied.

Please translate the pop up message you got.

Cheers!
A

UCiccola Frequent Visitor
Frequent Visitor

Re: Connect to excel files on sharepoint

Hi,

 

I simply import a Sharepoint List, then open the tables where i have the files, and i finally expand the content.
When i tried with xlsx files or docx files i have the following error:

"We have not recognized the format of the first file (lnk2140). Filter the list of files so that it only contains the supported types (text, csv, excel books, etc.) and try again"

But when i expand pdf files i dont have this error. Neither with csv files.
An xlsx file isnt a "Excel book" type?


Thanks

Community Support Team
Community Support Team

Re: Connect to excel files on sharepoint

HI @UCiccola 

 

One of the reason could be that the data that you are importing to PBI is not in excel table. Select the rows and columns from the sheet that you want to import >> Insert Table in excel and try importing it should be able to read the data then.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
UCiccola Frequent Visitor
Frequent Visitor

Re: Connect to excel files on sharepoint

Hi @v-diye-msft 

 

The thing is that is not only one file. I have millions of files, this is a test i´m doing to migrate all the files to Sharepoint.

The file is an excel file, in fact de extention is xlsx as i said. Isnt that an excel extention?


Thanks

Community Support Team
Community Support Team

Re: Connect to excel files on sharepoint

Hi @UCiccola 

 

Yes, it is. I won't know where's the point coz I can't replicate your issue. I'd like to suggest you raising your question to support team for better advice. 

https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 53 members 833 guests
Please welcome our newest community members: