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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
BhavnaB
Regular Visitor

In what order are reports returned when calling GetReportsInGroupAsync

We are using Embedded Bi.

 

We use the GetReportsInGroupAsync method to get a list of reports in a workspace and display to our users.

 

In what order are these reports returned?

How can i control this if i want to display the reports in a specific order?

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @BhavnaB,

Yes, I think it is possible to change the report list orders.

AFAIK, GetReportsInGroupAsync will return a list of reports. You can create a dictionary table with name/key and index and used to compare with current report key with the dictionary table and fill them into another list based on the dictionary table index in looping functions.

After these steps, you can use the new list as source in the following operations and it will keep the 'sort order' as same as your dictionary table defined.

Tutorial: Embed Power BI content into an application for your customers#get-the-content-item-you-wan... 

Integrate Power BI into Your Application: Part 3 – Embed Content 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @BhavnaB,

Yes, I think it is possible to change the report list orders.

AFAIK, GetReportsInGroupAsync will return a list of reports. You can create a dictionary table with name/key and index and used to compare with current report key with the dictionary table and fill them into another list based on the dictionary table index in looping functions.

After these steps, you can use the new list as source in the following operations and it will keep the 'sort order' as same as your dictionary table defined.

Tutorial: Embed Power BI content into an application for your customers#get-the-content-item-you-wan... 

Integrate Power BI into Your Application: Part 3 – Embed Content 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft 

 

Thanks for the suggestion. We will use dictionary tables to sort them before displaying.

 

Would you know if there's any logic to how the reports will be returned by theGetReportsInGroupAsync , like last updated or in the order they were uploaded?

Hi @BhavnaB,

In fact, GetReportsInGroupAsync is a function to get report lists. I double-check on it but not found any writeback feature to submit changes back to power bi.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Kudoed Authors