Some columns are missing when data is imported to powerBI using OData

[awgnanaw]

when I use OData to import data from ODK to PowrBi, some columns do not show up in PowerBI. what could be the issue?

[danbjoseph]

Here is a post from the forum about missing fields when pulling data from Central into Power BI:

ReviewState does not appear during Central OData transfer to Power BI

Review state is in the __system column. You can confirm, by following these steps. From Home, click on the Transform data in the menu bar to open up Power Query. On the right-hand side of the screen, you should see the list of Applied Steps. Click on Navigation. Now at the top of the screen, you should see your __system column. Expand it. You should now see reviewState. [Screen Shot 2021-06-30 at 09.18.19] As to how you adjust your Power BI dashboard to include that new column, that's depen…

I think your issue might be similar to an issue with connecting Power BI to KoBo and columns without data not being included in initial data pull configuration.

All columns do not appear when connecting to powerbi

[Neil_Moloney]

How are you importing the data into PowerBI? Are you using the wizard, M, DAX? All of these have their quirks! However, if you're using the wizard (PowerQuery), you may need to expand the columns before you load them. In the Power Query Editor you are able to expand columns, for example at the Source step you may see a column such as Data (as an example). On the right hand side of that column header, you may see something that looks like two arrows heading up and then splitting left and right. Click on that to Expand that column and follow the wizard (I generally unclick the "Use original column name as prefix" option. There are many Youtube tutorials on PowerQuery online - this may be a starting point for solving your issue!

Neil.

[Neil_Moloney]

Oh, this was a duplicate question...