Power BI not refreshing online when getting JSON data from kobotoolbox api

Hi Soabie_Mando ,

-- “We cannot convert the value “[Record]” to type Record”
Please check the threads below. Please try to set the query that expands the source of the column name to the same privacy level as this query.

In PBI Service, the privacy level is under Gateway Connections.

Solved: Expression.Error: We cannot convert the value "[Re... - Microsoft Fabric Community
Solved: We cannot convert the value "[Record]" to type Lis... - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum