Requirement to embed a dynamic report on a website

I am new to Power BI and wanted to confirm if Power BI can support the requirement I have.

I need to extract data from mySQL for the creation of the report. Have therefore installed the desktop version of Power BI.

I then need to create reports that are to be embedded in our website that users will access using their supplied User ID and password.

Additionally, the same report needs to be displayed for different users based on the institution from where they are logging on. So if they log on from University X then they need to be displayed data for University X. The report is the same but the data is different. Do I need to create different reports for all the institutions separately or can this be dynamic and I just create one report?

Also, can Power BI reports support filtering by time? So if I want can I see data for a month/year etc.

Re: Requirement to embed a dynamic report on a website

1. the same report needs to be displayed for different users based on the institution from where they are logging on. So if they log on from University X then they need to be displayed data for University X. The report is the same but the data is different.

Re: Requirement to embed a dynamic report on a website

1. the same report needs to be displayed for different users based on the institution from where they are logging on. So if they log on from University X then they need to be displayed data for University X. The report is the same but the data is different.

---> My requirement is to embed a report. In that scenario the logged on external user will be using their credentials for our website. They are not Power BI users and not internal to the organisation. How would row level security work in this scenario?

If you are embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly.

If you're embedding for non-Power BI users (app owns data), which is typically an ISV scenario, you need to configure the embed token to account for the user and role. Read article below to learn how to do this.