Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |