Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |