Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bhanupowerbi
Frequent Visitor

User specific report

Hi All,

 

I am having a problmn in showing user specific reports.

 

I have my database in SQL SERVER where I have cummlative data of all the user.

I have inegrated Power BI in my Web Application to show reports.

Now I want to show report data specfic to the person who has loggged in, but unable to find any way.

 

Is there any why where I can send the dynamic data depending upon the person logged in to power BI to genrate report?

 

Any help will be appreciated.

2 REPLIES 2

@bhanupowerbi You can achieve this by using Row Level Security.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Hi @Seth_C_Bauer,

 

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.

Refrencehttps://azure.microsoft.com/en-us/resources/videos/build-2016-integrating-power-bi-into-your-own-app...

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.

 

 

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors