Use ODATA in Power BI to access FAB Formdata

 Customers may request the ability to pull the data from the FAB forms into an Analytics tool.

One solution is to utilise the ODATA service.

Sample ODATA:

http://fioriqas.iqxbusiness.com/sap/opu/odata/IQX/FAB_SRV/FormData3?$filter=ZFORM_NAME eq 'CLT_WSD_FI_PAYMENTS'

Start PowerBI (you can use the free PowerBI Desktop Version to achieve this)

Enter ODATA URL

Enter BASIC authentication – and provide a SAP Userid/Password

Click “Transform Data”

Select ZDATA Column, Right Click, Transform, JSON

 You now have the column data you need.

We are now done with transformations – click close and apply

We will put the important columns into a TABLE and then we can EXPORT the table content to CSV.

Now we have a table on our reporting view, we just add the fields we want to report.

Suggest you add all the fields intially into the table.

Now to get the table of data out into a CSV file, there are 3 dots in the table display, select them and “Export Data”

You now have the required data in CSV format.

End  of instructions.