Connecting data to Power BI

User Support Data Management
,
1

Hello,

I have tried doing the recommendation as in the trail, but failed to succeed. Thanks for your help.

image
image940×466 150 KB

image
image940×451 105 KB

image
image940×1426 120 KB

image
image742×689 109 KB

Best

2

https://community.kobotoolbox.org/t/connecting-with-power-bi/9413/13?u=suunak

3

Welcome back to the community, @Suunak! Have you tried using this new API? It should help you solve your issue:

4

I have failed. To fix this. Thanks for your further advice.

6

While using this new API-URL with Google sheet IMPORTDATA function, at about 4000 submissions of data with about 33 columns, it starts returning the error - “Resource at url contents exceeded maximum size.”. Does this work when we have a smaller dataset only?

7

@tomisin, this support article Connecting KoboToolbox to Power BI updated recently should help you solve your issue. cc: @Suunak