Hi,
We are planning to use Power BI for reporting needs in project. Currently we are trying to checkout features of Power BI and see if these can be achieved, so far we have not been able to make much progress on this. Can someone please provide pointers on
how this can achieved,
Its Angular app with .NET Core middleware and Azure SQL DB back-end.
1. Application has 4 screens each displaying different dataset. There is a Preview button on UI, on clicking the button, a consolidated report from dataset in all 4 screens has to be displayed on a dashboard and this dataset is for a particular date user
would have selected on the screen. We found few articles that explain how to embed Power BI reports on Angular app which we are yet to try out. But, are there ways to pass parameters to Power BI dashboard like a particular date, looks like
dashboard URL by default loads the entire dataset and user has to interact with the report for using filters.
2. On certain user action on the UI like button click event, report for the particular selected date has to be extracted as an excel (with all the report dashboard formatting intact) and emailed as an attachment to certain distribution list.
Looking for pointers/options to implement these.
Thank you.
Not able to find a relevant category for Power BI so tagged to Other Forums.
