Get Dynamic Data from User ID

[Anonymous]

Dears,

I really need to know how to get the data dynamic based on the User ID. I am using Jason URL WEB to get my data.

I have dataset for eg A where i have all the user Name their desgination their manager name and their User ID which is Unique "/api/Project/GetUsers".  I have another dataset from where i am getting the user details using their ID "/api/Timesheet/getTimesheet?UserId=(user ID)". I need to pass a parameter where i can get all the user timesheet. I do not know how to do this, but i understand this is doable.

Thank You In Advance For Your Time.

Regards,

@Anonymous 

[v-kkf-msft]

Hi @Anonymous ,

Do you want to filter the data set when connecting to the data source, or during the modeling process? What is your expected output? What type of parameters did you mention?

Best Regards,
Winniz

[Anonymous]

I have reply 2 times @v-kkf-msft but its not showing, Still i did not find my answer i will reply to general so atleast my concern will appear.

I do not want to filter data, i want to get all my different data in 1. Let me explain in details.

Dataset A i have the list of all projects with their name and unique Id.
Suppose i have 10 project and all the projects have unique ID. As i am using Jason to view my report for a specific project i have to use the Project Id of that particular Project to view project information and detail.

Now i want to build a new Dataset B where i can get all the 10 projects Information and details at 1 place. How can i do this in Power BI using parameters of project unique ID.

Thank You,