cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User II
Super User II

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 to show some valid proof (PoC) so please if you have any links or deets kindly share it with me.
It's quite urgent.
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance on newly created report:
My Report
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Which source is faster (Excel or SQL server)

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.
LinkedIn

 

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Which source is faster (Excel or SQL server)

Hi @Tahreem24 ,

Hopes the following links can produce some help:

  1. Excel vs SharePoint vs SQL Server vs CDS 
  2. 3 reasons why you should prefer SQL server over MS excel 
  3. Excel to SQL: Why You Should Make the Switch 
  4. 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.

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Which source is faster (Excel or SQL server)

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.
LinkedIn

 

View solution in original post

Highlighted
Super User II
Super User II

Re: Which source is faster (Excel or SQL server)

@Mariusz ,

Thanks for your reply.

Yeah I know SQL is faster that Excel. But do you have some links because I need to create POC so require some links or reference for this.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance on newly created report:
My Report
Highlighted
Microsoft
Microsoft

Re: Which source is faster (Excel or SQL server)

Hi @Tahreem24 ,

Hopes the following links can produce some help:

  1. Excel vs SharePoint vs SQL Server vs CDS 
  2. 3 reasons why you should prefer SQL server over MS excel 
  3. Excel to SQL: Why You Should Make the Switch 
  4. 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.

View solution in original post

Highlighted
Super User II
Super User II

Re: Which source is faster (Excel or SQL server)

Thanks a lot @v-yingjl and @Mariusz for sharing the insigthful links and details respectively!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance on newly created report:
My Report
Highlighted
Microsoft
Microsoft

Re: Which source is faster (Excel or SQL server)

That's my pleasure😀.

 

Regards,

Yingjie Li

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors