ReplaceValue function no supported in Dataflows?

[Anonymous]

Hi all,

I'm currently working on moving the ETL logic (PowerQuery) from a .pbix file to Power BI Dataflows.

I am not able to validate the queries and load the entities. I receive an error message stating that one of the Quereies has an error, specifically the step that uses the function ReplaceValue to replace specific values form a column.

Is ReplaceValues not supported in Dataflows yet? Is this function limited in some way?

Thanks in advance for your help.

[v-frfei-msft]

Hi @Anonymous ,

In that manner, the processing of large data is performed online in dataflows, rather than being performed locally in your running instance of Power BI Desktop.  So we cannot take replace values in power query as the normal way.

[sommarafton2]

Thank you. Could you explain what you mean by "take it the normal way"? Is there another function that can be used or are you saying this is a tranformation that always needs to be done in the report itself? Also, is there a list of unsupported or supported M functions somewhere? Thanks in advance!