Andy Clapham on 09 Oct 2023 16:26:03
The experience of editing a power BI data model from the report editor screen is particularly unpleasant.
In a large model (say 80 queries with a few dozen fields each, maybe 20 measure "tables" with a dozen measures in them) adding a measure or calculated field can take 2 minutes before even being allowed to enter anything.
Feedback on syntax/missing fields takes an equal amount of time, often blocking the UI thread so that keystrokes aren't registered correctly.
Changing a field type, format, name or adding/changing a relation in a model is similarly slow.
Having to wait minutes between every single edit action makes it a real ordeal to try and update a report, the editor should allow you to edit "at the speed of thought".
What is actually happening here? Has anybody every profiled the code?
It's not rocket science to efficiently parse and refresh an in-memory graph of the data model ... it's computer science ;)