Forum Discussion
Automated Testing of Power BI Report Layout
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
5 Replies
- BhaveshPatelSuper User
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.
- chinnah1New Member
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
- AnonymousNot applicable
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
- vishnupriya18New MemberHi 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 [email protected]
Thanks,Vishnu Priya- curtispHelper II
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.