First of all I have little knowledge about power BI and even less about Azure or cloud/database programming. Also, I hope that this is posted in the right section.
I'm trying to build a client portal (via Wordpress) in which clients can log in and see their data (MySQL) presented in a organised and professional way (visualised graphs/tables by Power BI).
I've made a simple FrontEnd with Wordpress on which clients can register and log in to get access to a private page. Each client wants to monitor specific data on their private page. All this data is gathered in a MySQL server.
I would like to use this data and generate specific visuals (using Power BI) and present (embed?) these sets of specific visuals on their private page in Wordpress. This means that each private page has different data and possibly different visuals.
So I'd like to see if it's possible to connect Power Bi and Wordpress in order to give clients access to their specifically requested data which sits on a MySQL server. Can you guys give me any advice on this?
I'm too inexperienced with Microsoft's products in order to be able to decide if this is the right way to present the data (with Power BI) or that I need to use a different tool (not microsoft related) in my case. When it comes down to it, Wordpress and MySQL are a must and can't be replaced. So the only "variable" tool in this case would be Power BI.
I've checked out these references after searching, however I'm not familiar with all the terms and still wonder how I can use wordpress to link its currently logged in username to request specific data through power BI which in turn uses the user-info to collect the right data form MySQL. How is all this related to Power BI Embedded for example and its pricing? How do I use the app token per user? What if a new user has registered on the Wordpress site....do I need to manually make a new workspace and request a token and make the visuals? I'd like to have this automated...but will this require a lot of programming? If so, what kind of programming? (I assume php for Wordpress's side and .NET for powerBI?)
However the row level security part is not clear to me. Is it possible that de different customers that login at the wordpress site only see there own data by using rules? In my case there is a Azure database that contains all the data of all the customers.