Report Test Automation by exporting data

Anonymous — Tue, 21 Jan 2020 20:21:44 GMT

Hello,

I am looking into building a test automation to verify whether the report is implemented properly by supplying mock data, and checking it on the report whether the expected values are shown. In order to do so, I need to export the report data and feed it into the test framework. I have checked both Java REST API and JavaScript PowerBI API, but all i see is the ExportData api in JS which exports the data in csv format. As our existing test framework is in Java, I was hoping that there is a way to get something like a JSON blob in Java.

Our backend is in Azure Analysis Services, and I have thought about getting data from there instead, since it will do most of the processing, but AAS also does not have a handy way to be queried by non-MS systems it seems.

I have checked the forum too, but with no luck. Is there a way to get data from either PowerBI reports or AAS using Java (preferably) or JS?

Thanks,

Re: Report Test Automation by exporting data

dm-p — Tue, 21 Jan 2020 20:59:44 GMT

Hi @Anonymous,

I haven't peronsally had a play with the approaches below yet, but am aware of them, which may be all you need to get started. If more specific help is required, then we'll probably need another user more skilled in these areas to weigh in.

MS provide third-party access to SSAS via XMLA endpoint, which is a SOAP-based protocol for working with Analysis Services, so any language with good SOAP support, so Java might be a better fit than JS here.

Note that XMLA is available in preview in Power BI, but only if you have premium, so SSAS might be the better option.

You should also be able to use XMLA in conjunction with SSAS-specific scripting languages:

Hopefully this should give you something to get started with.

Good luck!

Daniel

If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

topic Re: Report Test Automation by exporting data in Developer

Report Test Automation by exporting data

Re: Report Test Automation by exporting data