Hi All,
I work for a large public hospital in VIC. We have just started using Power BI. We are looking at replace our custom developed Data & Analytics (D&A) Report catalogue developed over 10 years ago on ASP.NET with a modern solution with better user experience and better security and functionality such as following.
1. Ability to interface with Excel, SSRS, Metabase and PowerBI.
2. Ability to provide powerful and flexible search of all the existing reports in our D&A Library.
3. Ability to surface useful and contextual metadata with search results.
4. Future-proof (i.e., adaptable and scalable)
5. Search not only the reports that users have access to but also the ones that they do not have access to.
6. One that needs least customisation, configuration and ongoing maintenance.
7. Ability for the users to request access to reports they do not have access to and automatic workflow for their managers to approve the requests if acceptable.
8. Ability for the users to provide feedback and comments on reports they use.
I am keen to know how many of these features are achievable out of the box in Power BI and for the remaining ones, how could those best be achieved through integration with other Power Apps or Power Automate.
Thanks,
Kal