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.
I'm still getting the same errorAugustoChaves
This is exciting. I think it would be nice to get confirmation from someone outside of the Build conference. I often see Microsoft make exciting announcements about changes in their PBI stuff, only to wait another year or two before it is available to customers. As an example. we need "developer mode" for the sake of git, and CI/CD, and we've been waiting for about a decade for these improvements that are underway. Yet it the GA still seems a long way off!
Can you please reopen that case of yours (2203310040005513) and ask for a status update on the professional support side (Mindtree engineers)? I'm guessing you will hear a totally different response than what you heard at Build. I don't that Mindtree will allow another customer to communicate with them about your case number. But if they can share the last four digits of the ICM number on the Microsoft side, then I should be able to open a new case without starting over from scratch. That will allow me to engage as well.Hi Augusto, were you able to refresh CalculatedTable/Composite Model in powerbi service? As of today(5/30/24) I can only use XMLA to refresh also.
Thanks!
Hey Julian! Sorry, didn't have time to check yet.
No worries! we will find out in the next releases very soon(hopefully)
Hope will have some good new 🙂