Forum Discussion
Does anyone know what this dataset refresh error message is trying to tell me?
- 4 years ago
Hi Anonymous
You can ignore the <ccon> this is just some HTML code.
What I would do is download and install the latest version of PBI Desktop, refresh and then re-upload it and see if that fixes the issue.
Hi elia22gr
What I would suggest is that there is a single table which is causing the error.
I would disable the loading of the tables and work through them one at a time to see which one is causing the error.
GilbertQThank you for your reply!
The problem solved in a very similar way. The table causing the problem was an append of 2 other tables that weren't loaded (disable load). Those tables' source was a csv file downloaded from SAP BW. The line that was promoted as headers had a null which suddently changed to blank. This column was deleted in the next step but it had a different "name" as it used to and this was causing the problem.
As the refresh on Desktop didn't have any problem, in order to find what was causing the error on service, I made a new dataflow on Service and copied the table that was causing the problem (with this action there was also copied and the tables that the final was depending on). There I found out the root cause and resolve it.
Hope this will help other people with similar problems.
- Darkgi_3 years agoNew Member
Muito obrigada! 😍 Estava com o mesmo problema e a sua resposta me ajudou a buscar uma solução. Havia uma coluna que estava com o nome em branco que eu havia removido em uma etapa, então quando removi essa etapa não apresentou mais erro nas atualizações do servidor. Estranhamente essa coluna sem nome não estava renomeada nas etapas seguintes como o seu caso, então não entendi porque ela causou o erro.