Connect to excel files on sharepoint

[Anonymous]

Hi,

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

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

[Anonymous]

Hi @Anonymous 

Please provide all steps applied.

Please translate the pop up message you got.

Cheers!
A

[Anonymous]

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

[v-diye-msft]

HI @Anonymous 

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.

[Anonymous]

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

[v-diye-msft]

Hi @Anonymous 

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/