[bromcom] Power BI - Accessing EHCP top-up funding

[Bezingatron]

I am creating a SEND register for schools in our MAT and I would like to include EHCP top-up funding. At present I cannot find the correct table/column to pull this from on the oData feed. On occasion, Bromcom has less-than-intuitive column names. Does anyone know which table this sits in? Cheers.

[Bromcom_Support_2]

I am creating a SEND register for schools in our MAT and I would like to include EHCP top-up funding. At present I cannot find the correct table/column to pull this from on the oData feed. On occasion, Bromcom has less-than-intuitive column names. Does anyone know which table this sits in? Cheers.

 

Hi Bezingatron

 

Thank you for the query. We have double checked and at present, EHCP Funding is not available as a data item in the oData MIS and Vision feeds.

 

The best option for you to obtain this data would be to use Adhoc/Quick Reports and Live Data feed to Power Bi. The attached guide should assist with this - https://docs.bromcom.com/knowledge-base/how-to-import-data-directly-into-ms-excel/

 

You can also raise this as a development request via the Support Portal and we will look to implement it in future releases.

 

Kind regards,

Bromcom Support.

Edited May 10, 2023 by Bromcom_Support_2

[Bezingatron]

Hi Bezingatron

 

Thank you for the query. We have double checked and at present, EHCP Funding is not available as a data item in the oData MIS and Vision feeds.

 

The best option for you to obtain this data would be to use Adhoc/Quick Reports and Live Data feed to Power Bi. The attached guide should assist with this - https://docs.bromcom.com/knowledge-base/how-to-import-data-directly-into-ms-excel/

 

You can also raise this as a development request via the Support Portal and we will look to implement it in future releases.

 

Kind regards,

Bromcom Support.

 

The Live Feed did the trick, thanks!

[Bromcom_Support_2]

The Live Feed did the trick, thanks!

 

You are very welcome

 

Take care