Forum Discussion

irhyne's avatar
irhyne
Frequent Visitor
2 years ago
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...
Need Help
  • irhyne's avatar
    irhyne
    2 years ago

    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. 

irhyne's avatar
irhyne
Frequent Visitor
2 years ago

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.