Column in Desktop vs column in Service

[WLFRD]

Hello,

a day or two ago, I started with Datamart in Power BI Service. I have made some reports in Desktop and now I would like to do the same thing in Power BI Service. I connected some SQL tables to Datamart and when I use the Power Query from Service and add a column and paste the column lines from Desktop into Service, I get the error: a cyclic reference was encountered during evaluation. 

Isn't that strange because it should be the same? What do I need to do to make it do the same thing as in Desktop?

Regards

[v-luwang-msft · Accepted solution]

Hi  @WLFRD ,

Try copying everything from the advanced editor in Power query, replacing the one in Service. 

Similar error code refer:

https://community.powerbi.com/t5/Power-Query/Expression-Error-A-cyclic-reference-was-encountered-dur... 

Best Regards

Lucien

[WLFRD]

This is a part of the column I copied from Desktop and pasted it into Service.

[amitchandak]

@WLFRD , Where is copied is very important, need what is before and after to check this error

[amitchandak]

@WLFRD , You pasted the power query code ?

where you pasted that? Code is usually the same, but make small changes in the connection setting