Forum Discussion
Removing data source but keeping data
We have taken on board a pbix file which has the data already in but the saource files that it refers to no longer exist. When we try to refresh the other parts of the program it fails at the old...
hi Anonymous
The only thing I cant think of is disabling "Include in Report Refresh" for that affected query.
I do have the same problem, the only solution that I've found is to enter data manually by copying and pasting your data in your table source.
The problem is that it doesn't take more than 3000 cell, so it will ask you to split your table into smaller tables and then it suggest you to append them into one table.
it does solve the issue, but still a poor solution.