Salesforce Power Bi

Need To Ember Power Report in Salesforce Using Lighting Component.
1. Custom lightning component for iFrame based Power BI report viewer
2. Configurable parameter to feed Case, Account and Report Id details.
3. Responsive design to fit the component in Lightning Page Layouts

Condition :
AC-1
GIVEN I am a contact centre agent
WHEN I view a Case record with Account and Contact ID populated
THEN I should see a component that presents Power BI data filtered to that customer record

AC-2
GIVEN I am a contact centre agent
WHEN I view a Case record with no Account and Contact ID populated
THEN I should see a message within the component advising to populate an Account and Contact on the Case

AC-3
GIVEN I am a contact centre agent
WHEN I view an Account record
THEN I should see a component that presents Power BI data filtered to that customer record
Description of the change

Enable the Salesforce connector to Power BI so that dashboards can be added to Salesforce Layouts that present data relating to that Customer, Subscription or Account

Why is this being requested?

Customer data relating to Marketing Cloud and other resources is not readily available in Salesforce CRM. Creating a component that can present conditional and configurable information, will improve overall CX & lead to better business and customer outcomes

Requirements

1) The ability to add a Lightning component onto a Salesforce layout that will present Power BI data

2) The ability to configure what data should be presented, based on the Object the component is being added to (ie Case or Account data)

3) The ability to filter Power BI data based on the record being viewed in Salesforce CRM