Sorry I am not a very technical person but I followed this method shown here:
Accordingly, I am using this API link to connect live data to Power BI:
https://kc.kobotoolbox.org/theshashipatil/reports/a6EeDXCBhKJuP2WZd3gsi3/export.xlsx
In the repeat_B file, only the latest data is displayed, Previously entered data in this repeat group is not displayed, You can observe that index in the repeat_B file starts from 3. Index number 1 and 2 are missing.
and here’s the actual form if you would like to try making some entries: Enketo Express for KoboToolbox
Thank you for taking a look at this:)