Get the data from email having a link

[Alirezam]

Hi friends.

 I am receiving an email containing a link if on which you click, you will get the CSV file. So the data will be accessible only when you click on this link. It is not an attachment. it is a link in email content. How can I work it out?

Many thanks

[V-pazhen-msft]

@Alirezam 

I am not sure what specific feature you are looking for from power bi, maybe ask the email sender how did he/she included the csv link?

Regards
Paul

[lbendlin]

Are you planning to use Power Automate or similar to process the incoming email?

You could parse the email body, extract the link, download the CSV, and store it on a sharepoint folder that Power BI can then access.

[Alirezam]

Thanks, mate, I will try this then but still wondering why this cannot be done in Power Bi...