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

[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