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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

loop through the column

Hi!

 

I have just one table with a column of names. 

name
aee1
aee2
aee3
aee4
aee5
aee6
aee7
aee8
aee9
aee10

 

I`m trying to get the data through rest api so I`m using the query link :    /rest/usermanagement/1/user?username="" . Instead of "" in the username attribute I have to add each username from the column with names (unfortunately, there`s no wildcard for this attribute that I could use to avoid looping through column).

 

What I have now

I enter manually the username to the query link and get the detailed info about user. Query returns xml formatted data (there`s no problem with expanding it in the Power BI) 

Capture1.JPG

 

(just one row with data about one user only).

 

And what I need is:

a lot of rows with the info about each user in one table. Maybe I need to write a function and pass the name column as a parameter to it, but I`m not sure how to do that.

 

Any help would be really appreciated.

 

Cheers

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Actually the initial problem was getting the list of all users with detailed info using crowd api. I found the solution using query parameter:

crowd/rest/usermanagement/1/search?entity-type=user&start-index=1000&max-results=1000&expand=user

 

In case anybody will ever need this 🙂

View solution in original post

7 REPLIES 7
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

If it is convenient, could you share some data sample and your desired output so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-piga-msft, Sorry for that, I edited the post and I hope it`s more understandable now. I`d be really grateful if you could help. Thank you!

Hi @Anonymous

 

Is it possible to share the pbix file?

 

Please see this post to get your question answered quick.

 

 

Regards

Affan

Anonymous
Not applicable

Hi @affan Thank you for your reply and for the link provided! I`m sorry if my post is still unclear. Unfortunately I cant` provide a pbix file because of the security reasons. But I can provide some more info about that if needed. Please, let me know if you have some questions about my post I`d be happy to talk! Best, Mariia

@Anonymous

 

1. Is your issue relevant to a single table or multiple?

2. If this is a single table, can you please share a sample of this table (by copy pasting the table in excel) atleast 10 records * you can change the actual records to be sample values.

3. If you are having this question to be resolved over multiple tables please share all the table's sample

4. If multiple tables are invlolved in the issue please also share the screenshot of the relationships.

 

Anonymous
Not applicable

@affan

1. I have just one table with one column 'name'.

2. Sure, here it is 

name
aee1
aee2
aee3
aee4
aee5
aee6
aee7
aee8
aee9
aee10

3. just one table with one column in it.

 

I also edited the post again and I hope it`s better for understanding now 🙂

Please, let me know if some more details are needed.

 

And thank you for your time!

 

Best,

 

Mariia

Anonymous
Not applicable

Actually the initial problem was getting the list of all users with detailed info using crowd api. I found the solution using query parameter:

crowd/rest/usermanagement/1/search?entity-type=user&start-index=1000&max-results=1000&expand=user

 

In case anybody will ever need this 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.