Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Best Practice - Import data from Excel Sharepoint

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?

Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    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.

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    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.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.