Forum Discussion
Error unable to refresh dataset
Each and every month I have to use Power Bi I get stuck around the same error but different scenarios. I'm at a point where I am seriously considering asking my company to shop for a replacement. Som...
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
You may try to add some steps in query editor to change type for all the columns automatically.For further,please have a look at below article.
https://www.thebiccountant.com/2017/08/10/table-transform-column-types-to-first-rows-types/
Regards
I'm a novice so excuse my question but can you explain why you think this will help? I'm still unsure why Power Bi behaves this way for not finding a column that's basically new instead of just refreshing my data and adding the new column. And where would I add this in my current query?
try this: acho que encontrei uma luz: https://www.youtube.com/watch?v=YCCMCIktTdQ