There is one table with original 723 columns when connect to power bi there are only 639 columns imported into the power query

User Support API
1

I successfully connect my kobo data into Power BI via API/ However, there is one table with original 723 columns when connect to power bi there are only 639 columns imported into the power query. Please help me with this/

2

Dear Kal_Lam,

I am encountering the similar problem, one of my table with 723 columns are showing only 639 columns in Power bi when connecting data from kobo via api v2.

Please kindly help me with solutions to fix this.

Best Regards,
Douanmany

3

@Douangmany, what is the total number of columns you get when you download your data in XLS format? Do you get all 723 variables?

5

Yes I get all 723 columns when downloading but in power bi it shows only 623 columns besides the other tables from the same link are able pull all data columns.