SharePoint PDF URL to Power BI

Hi eb1362 ,
Thanks for amitchandak  reply.
According to your description, you want to get the record about the downloads on sharepoint and create a report to display this record which needs to contain the url of the particular file.Here are some steps that you can refer.
First, we want to review all the files downloaded from a specific SharePoint Online site set. You can search based on your desired time range and specified date interval and then go to that search to export as csv file
SharePoint Online: How to Track Document Downloads from Audit Log? - SharePoint Diary
Auditsearch 
Search the audit log | Microsoft Learn
Secondly, import the csv file obtained in the previous step into your power bi and set the file path as a hyperlink. Please note that it must start with http, https to be recognized.
Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

Best regards,
Albert He

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