Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
This is mildly infuriating to say the least...
Just changed the name of some workspaces (introduced seperate test and production environments) and had to therefore update the sources in one major report that has taken a lot of time and effort to develop and which accesses many different sources. Nothing else changed, just the name, which is a one-click update (change datasource) in every other report.
It has always worked just fine up till now (it refreshed just fine too), using field paramaters, a calculated column and a several calculated tables. Now, republishing with the new name, I get an error and it won't update anymore. Nor can I revert my changes...
I understand why I'm receiving this error, but that doesn't help me much unfortunately.
Seems like Build 2024 brought good news. In theory this "issue"/"design flaw" is now fixed and it is now possible to refresh Calculated columns and Calculated tables. I don't have a built test scenario but will try soon.