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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Extract Layout using script

Hi,

 

I would like to extract all information provided during creating visual  (e.g. Filter visual has name, font size, font color, font size , Alt text , etc) from all tabs using script. 

 

The motive is for Accessibility testing. Exported csv/xml file has all information about visuals and i can easily identify that which visual has not enough font size, color contrast, missing Alt text ,etc are not complaint with WCAG 2.0 AA / AAA.

 

Looking for any such script which extract these information from power bi.

 

Thanks,

Dipan

1 REPLY 1
Anonymous
Not applicable

I really appreciate your effort. It is really important to test these and ensure that the web apps, reports, dashboards are more inclusive. Having said that, I don't know if there is any script that does this, but if you know any programming language like Python, you could write a script and parse the report layout file to this python script and get the relevant output.

 

The approach is, once you create your report, do the following...

 

1) Make a copy of your report PBIX file.

2) Rename the extension of the copy from '.pbix' to '.zip'.

3) Then, open the zip (compressed file).

4) It will have a folder named "Report"

5) If you open the folder, there will be a file named "layout".

6) If you open this file using any text editor or code editor like VS code, you will be able to see all the report details like sheets, visuals, and all the properties of the visuals in your report. It looks like a ".json" file, but I am not sure.

 

At this level, you have all the details about your report, visuals, properties of visuals like font sizes, colors, etc... Though it is in human-readable form, it is not comprehensible or not very easy to find the properties. So it is better to write a script in Python or if possible import it into another Power BI Desktop file, do some transformations and try to make sense of it.

 

Disclaimer: I don't know if there is a better way. But if you don't know about any other option, you could approach it this way.

 

@Greg_Deckler 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors