How to loop excel in power bi

[arvindyadav]

Hi Team,

How to loop in excel which comes from onedrive for business means I want to push excel sheet in one folder with the same format in onedrive how can adjust and refresh it in power bi desktop.

Please help me out.

for more detail find attached.

In attachment, I have pulled excel name as detail_call_report_10-06-2017 from onedrive for business now I want detail_call_report_11-06-2017 with the same format from onedrive . what should I do for it?

Regards,

Arvind

[v-huizhn-msft]

Hi @arvindyadav,

detail_call_report_11-06-2017 data and detail_call_report_10-06-2017 are in same sheet for different sheets in the folder? Based on my research, there is no OOTB data source we can use to type the OneDrive for Business folder path. As you know, the SharePoint Folder data source can only be used for typing OneDrive root URL rather than folder path. One workaround you can try is Set up your computer to sync your OneDrive for Business files in Office 365, then use Folder data source to get folder from OneDrive for Business.

In addition, for loop in Power Query, this a similar thread for your reference, please review and check if it's useful. I am not specific with Power Query, you can get dedicated support in Power Query forum.

Best Regards,
Angelia