Error processing dataset

[Syndicate_Admin]

Hello everyone! I need your help with this error that comes out every time I try to update my dashboards:

Processing error: We cannot convert the value null to type List.
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 96ce00d2-0637-43f9-a596-0e4225cf978f
Application ID: 36664a59-aada-a155-300a-2ab3821b95f5
Time: 2021-09-14 14:08:54Z

Does anyone know how I can solve this problem? help po please

[v-jingzhang]

Hi @Syndicate_Admin 

Open Power Query Editor and find out on which step this error starts to occur. Then fix it there. These links may be helpful:

Power Query - Common Errors & How to Fix Them - Excel Off The Grid

Dealing with errors | Microsoft Docs

If it happens on a column which should have List values but sometimes may have null values in the data source, you can consider inserting a step to remove null value rows if you don't need them. Or replace null with other values if you want to keep the rows. You can also use try ... otherwise ... expressions to deal with errors. See M Language Error Handling

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@Syndicate_Admin , do you have a list column coming from your data source?

You might have converted it into columns and rows. That is giving problem. Open power query and check for more details