Using Power Automate to send email and export to share point
Hello, I have this confusion that I need some clarification. I have a requirement to refresh, automate emailing (MS Outlook) Power BI reports in excel format from Report server and publishing the reports to share Point. Can I achieve this using Power automate? My Thought is to create report on Desktop, publish to report server and schedule Refresh in report server, use Power automate to send email to distribution list since emailing is not supported by Power BI desktop in report server. I am cosidering this because I have difficulty creating connection between report builder 32bit and oracle database but I am able to create connection between Oracle database and Power BI Desktop. I need to know if this scenario works?