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. 

mattiasdesmet's avatar
mattiasdesmet
Icon for Resolver II rankResolver II
2 years ago

Did you do any SQL Profiling on the query being sent out from the service? Perhaps it helps to narrows down where this occurs (or does this happen immediately when refreshing?)

Can you post the full error message?

Do you have different datasources configured on the dataset in the service through a gateway?