Connect files from Sharepoint Folder and in future it should be added automatically

[Kavita123]

Hi,

I have one query regarding sharepoint folder multiple files.

In my task, I have total 40 files in sharepoint folder which has multiple sheets.

I want to connect that all 40files in power bi desktop, also this report is dynamic so if any new Excel is introduced in the folder all the transformations get applied to that file & it gets added automatically to the final report.

Is there any solution for this task?

[v-kongfanf-msft · Accepted solution]

Hi @Kavita123 ,

You need to connect the sharepoint folder in powerbi. Refer to the following steps:

Note that when connecting to a sharepoint folder, you can't connect directly to a subfolder; instead, you must connect to the root directory and then look down until you find the desired folder.

The user will be prompted to authenticate their login as follows, and they will need to log in with the appropriate credentials.

Successful connection to excel file in sharepoint folder.

When there is a new excel file in sharepoint, the latest data will be synchronized after refreshing the refersh button in the power query.

For more details, you can refer to below document:

Power Query SharePoint folder connector - Power Query | Microsoft Learn

Best Regards,
Adamk Kong

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