cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SH-VE
Helper IV
Helper IV

SharePoint excel files Vs SharePoint list

Hi All, 

 

I wanted to seek opinions on best pratice for using Sharepoint files. 

 

In my report, I need to use five different Sharepoint files from same SharePoint folder . I feel that it is slowing down the report and throwing strange error message . 

 

Please suggets what is the best practice. In cases where more than one SharePoint file needs to be used, is using sharePoint list better than using excels  ?

 

Thanks.

Snag_a49472.png

1 ACCEPTED SOLUTION
edhans
Super User III
Super User III

SharePoint Lists are different than Excel. I prefer them for user data entry because you can lock down what the user can enter and they cannot override it accidentally. Even with Data Validatation users can just paste data and override your requirements.

But if it is something exported out of another system, I'm ok with XLSX (NOT XLS) because it is usually identical every single time - computer programs don't change output much. Even ugly output - once you get the M code right, it just works.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
ERD
Solution Sage
Solution Sage

Hi @SH-VE ,

Are we talking abount SharePoint Online?

If so, have a look at this video: A cleaner way to import files from a SharePoint folder with a Power Query function.

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

 

edhans
Super User III
Super User III

SharePoint Lists are different than Excel. I prefer them for user data entry because you can lock down what the user can enter and they cannot override it accidentally. Even with Data Validatation users can just paste data and override your requirements.

But if it is something exported out of another system, I'm ok with XLSX (NOT XLS) because it is usually identical every single time - computer programs don't change output much. Even ugly output - once you get the M code right, it just works.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors