Hi!
I need to query SAP HANA and show the results of the reports to the organization. My first thought was using Power BI, but there are no licenses available. So, I think my option will be using Power Query to Excel, publishing it in SharePoint, and using Power Automate to keep the information updated.
The problem is that I have never used Power Automate before, so my questions are:
- Can I automate a query in Power Automate, or do I need to create the query in Power Automate?
- Is it possible to create the entire report in Power Automate without Power Query or Excel?
- Do you have a recommended course for reporting using Power Automate?
Any tips and recommendations will be appreciated."

Report
All responses (
Answers (