Onedrive generate links (embed codes) in bulk

Hi,Syndicate_Admin 

Regarding the issue you raised, my solution is as follows:

1.Use the OneDrive API to get a list of all the files in the folder

Use the Microsoft Graph API - Microsoft Graph | Microsoft Learn

Then use the PowerBI API to import the embedded code into the PowerBI report.

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn 

Call a REST API method：

{HTTP method} https://graph.microsoft.com/{version}/{resource}?{query-parameters}

2.You can also use powerbidesktop to read the file data in OneDrive, then use powerquery to process the data and upload it to the service to generate an embed code.

Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

Embed a report in a secure portal or website - Power BI | Microsoft Learn

3.Finally, you can also use Power Automate to create a process that automatically fetches a list of files and generates the corresponding embed code for PowerBI.

Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

If you have any new discoveries, please feel free to share them with us.

Best Regards,

Leroy Lu

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