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: ...
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.
