Unable to refresh dataset

[Anonymous]

Hi, I have encountered an error when refreshing the dataset through Power BI Service. However, the refresh works fine when I do it using Power BI and then publish it manually.

Data source error: Expression.Error: We cannot convert the value <pii>"[Table]"</pii> to type <pii>Table</pii>.. Value = <pii>[Table]</pii>.

After deleting step by step and trying to refresh, I realised that the error is due to this line of code:

Table.AddColumn(Custom1, "LatestVersion", each "FW-20-2022"),

I'm trying to add a custom column to my table, that's all.

Wondering why it works in Desktop but not on the Service.

[Anonymous]

@lbendlin

Thanks for your response.

I do have tables like this, but those are in steps way above the one that is causing this error. I deleted each step along the way from the end, published and tried to refresh on PBI Service again, it is due to this line:

Table.Combine({#"Renamed Columns3", ABC})

ABC is another query with the same number of columns. My intent is to append this table ABC to my original table.

After removing this line, I am able to run the refresh.

[lbendlin]

"with the same number of columns"

That is not really required.  It is more important to know what column types that table has.  Check for any weird ones.

[lbendlin]

That's likely not your issue.  In your Power Query last step do you see any links like this?

the yellow-ish "Table"  link indicates that the table cell contains another table.   This is fine in Power Query, but Power BI doesn't know how to handle nested tables.