User specific report

Hi Anonymous,

Thanks for the reply.

In Row Level Security I need to have some groups or something to filter and assigne user everytime some user added to my application.

My goal is to show user specific power BI report in my .net application.

Approche's i used till now.

--------------

Approch 1

---------------

1. I have connected my Power BI Destop to my DB (GET DATA).

2. Now Table has data of all the user.

3. Created Visuls with data.

4. Uploaded the .pbix file to my workspace in Azure.

5. Integrated the Power BI in my Application and got reports from azure and showed it.

6. Now catch is the report will show data of all the user but, I want to show data of only user who is logged in to my application i.e. report should filter data according to user ID and don't show visula with other user data.

Refrence - https://azure.microsoft.com/en-us/resources/videos/build-2016-integrating-power-bi-into-your-own-applications-featuring-real-world-demos/ 

http://www.mostafaelzoghbi.com/2016/04/power-bi-embedded-step-by-step.html

----------------

Approche 2 (currently using)

----------------

1. User logged in to my application.

2. I have fetched the user specific data from DB.

3. Created the Dynamic DataSet in Power BI.

4. Add rows in dataset.

5. Created Visul related to dataset 

6. saved it to report/daseboard

7. will integrated report/dasboard to my application and will show report to user.

Issue here is-  

1. how to filter data of report according to logged-In user in my application.

2. If I create Dataset for everyuser evert time they log-in and delete it when they log-off, then how will I automate the process of creating same visula for all data set and save tht report with some unique name

If I am doing some silly mistake. Kindly forgive me.