Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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.
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.
User | Count |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |