Report Test Automation by exporting data

[parkn]

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,

[dm-p · Accepted solution]

Hi @parkn,

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.

• Developing with XMLA in Analysis Services 
• XMLA reference

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

• Developing with Analysis Services Scripting Language (ASSL) 
• Tabular Model Scripting Language (TMSL) Reference 

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 🙂