Solved: Can't replace data source

serena11 · ‎10-10-2019

My report will not update my data source because it says that a column in my table cannot be found, despite it being in the same psoition and under the same name. How do I get around this?

dax · ‎10-10-2019

Hi serena11,

You could try to refresh the dataset manually to see whether it work or not. Or you could try to re-create the dataset, then rename this dataset to your original table' name(you should rename the original to other name at first)and re-create relationship on this dataset to see whether the report work well or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dax · ‎10-10-2019

Hi serena11,

You could try to refresh the dataset manually to see whether it work or not. Or you could try to re-create the dataset, then rename this dataset to your original table' name(you should rename the original to other name at first)and re-create relationship on this dataset to see whether the report work well or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.