Missing Columns from Sharepoint Data source

[ottiphi]

Hello all,

I'm running into an issue where a couple of the columns from a Sharepoint List is not shoqing up within Power Bi. Those columns are neccessary for what I need to do, and I need to utilize the refresh function so I can't export to excel and import to Power BI. 

Thanks in advance. 

[v-yuezhe-msft]

@ottiphi,

What columns do you want to get? Have you expanded the "FieldValuesAsText" column in Power BI Desktop?


Regards,
Lydia

[QuinnP]

Thanks, this answer was exactly what I needed!