Dynamic API INPUT

[Anonymous]

Hi All,

We have developing an webhosted application, which shows all the data related to their Azure Subscription and planning to integrate the Powerbi dektop with the appication. When the user logsin he/she sholud be able to see data related to their Subscription. 

Currently we are taking the source data from API url, now here we want to make the Source connection dynamic depends upon the user who logs in.

Thanks,

Sai...

[Anonymous]

Hi @Anonymous ,

To make the source connection dynamic, you can follow these steps:

1. Implement user authentication: You need to implement a user authentication mechanism in your application so that each user has their own credentials and can log in securely.

2. Retrieve user information: Once the user is authenticated, you need to retrieve their information, such as their Azure Subscription details, from your application's backend or database.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

Hi Stephen,

Thank you for your reply.

To elaborate further on the application functionality:

A user signs up using their Azure subscription, and a new ID is created in the application corresponding to their subscription ID.

Through an API, we fetch all the data related to the user's subscription and display it within the application. In addition, we showcase an embedded Power BI report.

We set the source of the Power BI report to a specified API URL, which varies for different users. For example, the URL format is:

https://pheonix-backend.azurewebsites.net/orphan_resources?subscription_id=xxxxxxxxxxxxxxxxxxxx&fino...

It's important to note that we are not using a database in this process. We aim to automate the population of data in Power BI, depending on the logged-in user and source url parameter(subscription id and finopsid also be switched to users). In the URL provided above, both the subscription_id and finops_id parameters change for each user.

Thanks,

CHS