Forum Discussion
Solved
Which source is faster (Excel or SQL server)
Hi Guys,
My client has asked if we connect Power BI report to SQL server or Excel sheet so which is one faster? I mean data from Excel is faster or from SQL Server of same size of data.
I need ...
Hi Tahreem24
SQL server as you can push the native query back to the server and use its resources.
When considering Excel then the location of the files ( SharePoint folder, data lake or local drive ) will have an impact on the performance.
Probably SQL will be faster most times and will give you an ability to Direct Query on larger data sources.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInHi Tahreem24 ,
Hopes the following links can produce some help:
- Excel vs SharePoint vs SQL Server vs CDS
- 3 reasons why you should prefer SQL server over MS excel
- Excel to SQL: Why You Should Make the Switch
- SQL vs Excel PowerQuery
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Tahreem24 ,
Hopes the following links can produce some help:
- Excel vs SharePoint vs SQL Server vs CDS
- 3 reasons why you should prefer SQL server over MS excel
- Excel to SQL: Why You Should Make the Switch
- SQL vs Excel PowerQuery
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.
