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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
runrunrun
Resolver I
Resolver I

Need help on Power BI Integration in .NET MVC app

Hi, I need some suggestion how to solve my problem.

First of all Power BI can't have real time alert (audible)  when some alert populate SQL Table. So I create custom MVC app that can alert and produce sound when there is "data insert into table". The data is linked to Power BI Reports so it can show daily trends and etc. My problem is user need to login with his/her Power BI Account to view Power BI Report in my app, so my app check if there is any access token in session, if not then prompt login page (see below)

https://login.windows.net/common/oauth2/authorize/?response_type=code&client_id=blahblahblah&resource=https%3a%2f%2fanalysis.windows.net%2fpowerbi%2fapi&redirect_uri=blahblahblah

I need to know how to get login information when the user sign in to get access token using this method OR How to use/push power BI login to my MVC app so user can see their own authorized report.

Thank you. Feel free to discuss it with me 🙂

1 ACCEPTED SOLUTION
runrunrun
Resolver I
Resolver I

Well, I have found the answer myself.

We can have the user info from Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationResult Object.

 

View solution in original post

3 REPLIES 3
runrunrun
Resolver I
Resolver I

Well, I have found the answer myself.

We can have the user info from Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationResult Object.

 

Eric_Zhang
Microsoft Employee
Microsoft Employee


@runrunrun wrote:

Hi, I need some suggestion how to solve my problem.

First of all Power BI can't have real time alert (audible)  when some alert populate SQL Table. So I create custom MVC app that can alert and produce sound when there is "data insert into table". The data is linked to Power BI Reports so it can show daily trends and etc. My problem is user need to login with his/her Power BI Account to view Power BI Report in my app, so my app check if there is any access token in session, if not then prompt login page (see below)

https://login.windows.net/common/oauth2/authorize/?response_type=code&client_id=blahblahblah&resource=https%3a%2f%2fanalysis.windows.net%2fpowerbi%2fapi&redirect_uri=blahblahblah

I need to know how to get login information when the user sign in to get access token using this method OR How to use/push power BI login to my MVC app so user can see their own authorized report.

Thank you. Feel free to discuss it with me 🙂


Check Row-level security (RLS) with Power BI. Note that RLS is a pro feature.

The User already have pro license, my problem is how to create mvc app (custom app that can create near real-time audible alarm in browser) that will using power bi login as credential. I can create my custom login page then user still login their power bi account, but double login like that won't be acceptable and it's not user friendly

this reference

Thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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