Forum Discussion

electrichead's avatar
electrichead
Frequent Visitor
1 year ago

Export a list containing: Report Page Name, Visual Name, and Source Table and Column Name

I have a report with several pages.  As our sources evolve and become better refined sometimes the table we initially used to "get things going" is replaced by a more formal source of data.  In these cases I need to comb thru the report and find where the old data is and point it to the new data source.  Tedious.

 

Is there a way to export a list that contains:

Report Page Name

Visual Name/Identifier

Souce table used in said Visual

Column Name from table used in said Visual

 

An example of this table might look like this:



When my BI report looks like this:

 

Again, with many pages I would want the table to include all the pages and all the visuals.

Thanks for any help!

Need Help

2 Replies

  • electrichead's avatar
    electrichead
    Frequent Visitor
    1 year ago

    Replying to myself... another way to think of or solve this would be:

     

    For a given source table, get a report out of everywhere columns in that source table are used.

     

    The output table would be the same as my original post, but with fewer rows since it's only reporting on one data source, not all of the data sources used in visuals.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi electrichead ,

     

    With power bi embedded analytics, after loading a report, you can create a list of pages or visual objects that can be used directly to change these instances. You can also create a list to see which visual objects are used on a particular page.

     

    The following code example demonstrates how to retrieve a collection of pages in a report, with sample output showing the page name and display name for each object.

    let pages = await report.getPages();
let log = "Report pages:";
pages.forEach(function (page) {
log += "\n" + page.name + " - " + page.displayName;
});

console.log(log);

     

    More details can be found in the documentation:

    Get pages and visuals in a Power BI embedded analytics application | Microsoft Learn

    Power BI embedded analytics overview | Microsoft Learn

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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