Excel source error

[Anonymous]

Hi everyone,

I have 56 'excel' files and in each file there are 5 tables, in each table there are 1100 columns and 400 lines, they are all located in 'Onedrive'. When I start connecting to them separately, PowerBI starts to hang.
I tried to connect via the Sharepoint, but the program constantly produces an error in the form "oledb or odbc error: [datasource.error] received an unexpected EOF or 0 bytes from the transport steam".

When I have less connection all works well.

How can I connect to the file in Onedrive, so that it can automatically update the data?

[Anonymous]

@Anonymous,

What bot version of Power BI Desktop do you use? And do you use February update of Power BI Desktop?

Besides, if you want to make OneDrive refresh work when you update data in Excel, you would nees to directly connect to the Excel files in Power BI Service.

Regards,
Lydia