Best Practice - Import data from Excel Sharepoint

[Anonymous]

I'm wondering if there's a better way to import data from Excel file stored on Sharepoint. The file is manually updated each morning and would like to view in Power BI. I have a Power BI that works well, except when refreshing the excel file. I'm using Web connector and it seems to work ok about 80% of the time and i think is because of the Excel source.

Any suggestions on alternatives to import data from the Excel file that might be a little more forgiving?

[v-yingjl]

Hi @Anonymous ,

You can use SharePoint folder connector to get all the files in this site, it will have a binary column which stores their file in Power Query Editor, when you click it, it will expand as a new table with a Data column with stores each file's data, you can click it to get these data when necessary to convert to a table in power query.

SharePoint folder link is like:

In power query editor

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix · Accepted solution]

Hi @Anonymous ,

If the file is stored on the sharepoint youbshould use the sharepoint folder connector not the web connector.

Mayb you an have better performance.