We cannot convert the value "[List]" to type Table. Table: PO Records.

[Vikram123]

Hi,

Data source is sharepoint list.

when i update or refresh in powerbi desktop then it's working fine.

when i published successfully. and dataset refresh manualy or automaticaly i got below error.

Please find below error.

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Message: We cannot convert the value "[List]" to type Table. Table: PO Records.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 96a69a55-fae5-4cc1-8b58-4098d5469e4a
Request ID: bd9d7f70-f0ad-b0a2-acc7-d1cc089f2a12
Time: 2018-12-21 05:43:14Z

[v-yuezhe-msft]

@Vikram123,

Do you have mixed data types(List and Table) in one of the columns in the PO Records table? If so, you would need to firstly check if current row of the column to expand is of type table , then expand values accordingly. For more details, please review the following similar thread.

https://community.powerbi.com/t5/Desktop/Expand-column-where-not-all-records-are-tables/td-p/79060

Regards,
Lydia