Forum Discussion
Unable to refresh dataset
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.
3 Replies
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.
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.
"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.
