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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bhanupowerbi
Frequent Visitor

Showing 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.

3 REPLIES 3
vineetakande
Frequent Visitor

Hi,

Did you find the solution for this?

v-sihou-msft
Employee
Employee

@bhanupowerbi

 

In this scenario, if you want each accessing users can only view their related data, you need to configure Row Level Security with dynamic row level filter. For more details, please refer to articles below:

 

Different approach to Dynamic Row Level Security

Dynamic Row Level Security with Power BI Made Simple

 

Regards,

Hi @v-sihou-msft,

 

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 (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

 

 

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

Approche 2 

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

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

 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.