Forum Discussion
Solved
Gateway Refresh Fails on "Ghost" Column
I have a report pulling from a SQL database that works great on desktop and had been working fine on the PBI service until a couple of days ago. Suddenly, it began failing on a data mashup error clai...
I just found and fixed the issue. It seems to be a PowerBI Service error. The query had several transforms, two of which included a table sort (not really necessary, but were there for the builders clarity in the construction phase). This seems to create a temporary column header "t0_0" which did not then go away but was invisible on load. When I removed the sort step from power query and re-uploaded, the error was gone.
mattiasdesmet
Resolver II
Resolver IIExcellent! Looked indeed a bit like some generated column, glad you discovered it