Automated Testing of Power BI Report Layout

[chinnah1]

Hi All,

Currently manually testing the layout of Power BI report. Eg: size and color of the buttons, alignment, gap between the rows & columns etc

 Is it possible to automate it? If yes, please give the details

Regards,

Harika

[vishnupriya18]

Hi Harika/Bhavesh,

Did you find any alternative solution to this probelm? I'm also trying to come up with an automation testing but couldn't find any pointers.

Appriciate If you could share your experiance and any possible solutions you find?

Feel free to email me at surabivishnupriya@gmail.com

Thanks,

Vishnu Priya

[curtisp]

check out https://www.thebiccountant.com/2019/09/14/compare-power-bi-files-with-power-bi-comparer-tool/   which is excel power query app that retrieves report layout information from PBIX converted to PBIT (template) file. The PBIT file can also be manually unzipped using Winzip. The resulting extracted files can be inspected. The comparer tool above does this.

[BhaveshPatel]

Hi @chinnah1

I don't think such tools exists to check these automatically.

You can use Gridlines and snap objects to grid when authoring reports in PBI Desktop to have a less painful experience.

[chinnah1]

Hi Bhavesh,

Is there any way we can export PBIX file to HTML or XMLA? so we can try access this file and look for properties of objects etc alignment ( x and y axis, font size, color etc)

Thanks,

Harika

[Anonymous]

Yes, 

There is a way to read PBIX as different data format but not in XMLA or HTML. If you extract PBIX file you will get a bunch of json files with metadata of the report.

Thanks,
Mani Kishan