topic Re: Automated Testing of Power BI Report Layout in Report Server

Automated Testing of Power BI Report Layout

chinnah1 — Tue, 21 Aug 2018 15:55:55 GMT

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

Re: Automated Testing of Power BI Report Layout

BhaveshPatel — Fri, 24 Aug 2018 08:14:06 GMT

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.

Re: Automated Testing of Power BI Report Layout

chinnah1 — Wed, 12 Sep 2018 10:06:23 GMT

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

Re: Automated Testing of Power BI Report Layout

vishnupriya18 — Fri, 18 Jan 2019 22:14:37 GMT

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

Re: Automated Testing of Power BI Report Layout

curtisp — Thu, 19 Sep 2019 21:52:26 GMT

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.

Re: Automated Testing of Power BI Report Layout

Anonymous — Wed, 23 Mar 2022 07:06:43 GMT

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