I just got into trouble as soon as i refreshed my dataset

vicks88 · January 23, 2021, 1:33pm

Hi Community,

i just got into trouble as soon as i refreshed my dataset.
It threw me the error below

But i do have this table in my dataset (shown in the pic highlighted in YELLOW)

Kal_Lam · January 23, 2021, 2:54pm

Could you please let us know the server you are using.

vicks88 · January 23, 2021, 3:10pm

Am on https://kobo.humanitarianresponse.info/

ks_1 · January 23, 2021, 9:33pm

As a general practice when working with APIs, try to use the /api/v1/data/<xform> link (without the ?format=<format> at the end). I have noticed that Kobotoolbox often returns inconsistent responses when the format tag is added.

The endpoint without the format tag returns JSON, and you will need to do 2 more steps in Power BI to convert it into table.

Please try this and let me know if it works.

vicks88 · January 25, 2021, 7:56am

Ok…& after establishing API connection and wwat about scheduling refreshes in PBI services…
My API doesnt refreshes…

PLs guide

vicks88 · January 25, 2021, 8:25am

Hi, pls guide… Its throwing error when am connecting it freshly even

Kal_Lam · January 25, 2021, 9:20am

Are you trying to connect your server with an Excel or with a Power BI?

vicks88 · January 25, 2021, 9:59am

Its Power BI

Kal_Lam · January 25, 2021, 10:04am

Are you still not able to link to power BI?

vicks88 · January 25, 2021, 10:23am

I have linked again by clearing PBI cache… Now its getting refreshed in PBI service after publishing…

But cant say in future wheather it fails again

Kal_Lam · January 25, 2021, 10:27am

Thank you for confirming that you issue has been solved by refreshing!