Using Power Automate to send email and export to share point

[M_nwadibia]

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?

[v-luwang-msft]

HI @M_nwadibia ,

Power BI Report Server support  subscription,in my opinion,it could achieve what you want :

Depending on the delivery extension you select, the following settings appear:

• Email subscriptions provide fields that are familiar to email users (for example, To, Subject, and Priority fields). Specify Include Report to embed or attach the report, or Include Link to include a URL to the report. Specify Render Format to choose a presentation format for the attached or embedded report. See Create an email subscription for details.

• File share subscriptions provide fields that allow you to specify a target location. You can deliver any report to a file share. However, reports that support interactive features (including matrix reports that support drill-down to supporting rows and columns) are rendered as static files. You cannot view drill-down rows and columns in a static file. The file share name must be specified in Uniform Naming Convention (UNC) format (for example, \mycomputer\public\myreportfiles). Do not include a trailing backslash in the path name. The report file will be delivered in a file format that is based on the render format (for example, if you choose Excel, the report is delivered as an .xlsx file). See Create a file share subscription for details.

To learn more details ,refer:

https://learn.microsoft.com/en-us/sql/reporting-services/working-with-subscriptions-web-portal?view=... 

Best Regards

Lucien

[M_nwadibia]

Hello,

The problem is that Power BI report is presently not supported for email subscription in report server. It is only paginated report that is supported for email subscription in report server. I am able to create ODBC connection to PBI desktop but unable to establish connection with report builder that is why I am looking for a way around it.