Forum Discussion

ffw105's avatar
ffw105
New Member
2 years ago
Solved

Scheduled refresh failed

Hi, My report is set to refresh daily at 12pm, it was all working fine till last night, and this was the error message:   Data source error: DataSource.Error: <ccon>Microsoft SQL: "Invalid column ...
Need Help
  • ImkeF's avatar
    ImkeF
    2 years ago

    Hi ffw105 ,
    I would go to the query editor in PBI desktop and look for the table where this error message has been generated.
    Proceed through every step of the query to see where it fails.
    Maybe the columns have been removed from the source?


ImkeF's avatar
ImkeF
Community Champion
2 years ago

Hi ffw105 ,
I would go to the query editor in PBI desktop and look for the table where this error message has been generated.
Proceed through every step of the query to see where it fails.
Maybe the columns have been removed from the source?


ffw105's avatar
ffw105
New Member
2 years ago

Hi ImkeF , thank you, I thought I was going mad as that was my conclusion too, we have contractors that have messed about the data source, that was the reason.