All columns do not appear when connecting to powerbi

[stephanealoo]

Hi @tom.joseph
I have gone through the communication trail above and I will narrow it to the last issue you raised as regards PowerBi.

@tom.joseph

The challenge is that unless I send in several test submissions that complete all of the possible fields within kobo, less than 50% of the fields will generate within powerbi. As additional submissions are created, that would then require additional ongoing maintenance to update the powerquery so that it accounts for the new submissions./columns.

This is an issue with PowerBi and how it pulls the data. As you rightly pointed out, you need to have data in all the columns to fully defined how you want those columns displayed. However, you could try adapting the fix done in advanced editor

Pulling data into PowerBI - errror due to columns not found in dataset

If you havent change “ABSOLUTELY ANYTHING” in the names…could be that Power BI changed the amount of colums ut is getting in the query… I usually go to the advanced query editor… [image] 1st setp is always the source… [image] if you have “columms”, like here…with a fixed number: [image] Remove it… [image] And click done. Helps?

I would also suggest you scheme through the following topics
Stephane