Power BI report optimization - Connection question

[J_S_A]

Hi.
I have developed a report in Power BI desktop that will be published in Power BI Service, so i need it to be as optimized as possible.

The data sources of the report are excel files stored in Sharepoint. I would like to know which is the best option to get the best optimization and performance of the report:

1) connect to Sharepoint through a Web connection, using the sharepoint URL (Get data -> Web)

2) connect directly to the Sharepoint folder (Get Data -> Sharepoint Folder)

Thanks in advance!

[v-karpurapud]

Hello @J_S_A 

Could you please confirm if your query have been resolved the solution provided by @lbendlin ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you

[lbendlin]

Door number Two, please.

NOTE:  The data source is Import Mode in both cases. So that will have NO impact on the performance of the report. Focus on optimizing the visuals'  queries.

[J_S_A]

Hi @lbendlin , many thanks for your answer!

Despite being in Import mode in both cases, doesn't the performance get impacted by the fact that when connecting through 'SharePoint Folder', the file search is done internally in Power BI using filters, whereas the file import through 'Web' connection is done online, searching for the document following a longer URL? I would like to understand why there is no difference between one option and the other regarding report optimization/performance, despite the document being imported in both cases.

In general words, you mean that the way you import a document doesn't impact minimally the performance of the report?

Thanks!

[lbendlin · Accepted solution]

Correct. At the end of the day all methods use the same Graph API calls internally.