Forum Discussion
PowerBI Writeback – Performance Issue
Hi ChrisCBR
You have your semantic model in Direct query mode, querying back to the same SQL database. You should then see those options change immediately after it is written to the database. Can you confirm that it has successfully written back to the database?
Yes, I can see the change in the SQL table from the writeback immediately. However, as mentioned, it takes about half a minute in direct query mode until I can see this change in the Power BI report. The workspace has a limit at the moment that report pages automatically refresh every 5 minutes, so I did the page refresh manually. This has no result until about 30-45 seconds. I thought the semantic model might be the performance bottleneck because it is the part where I had to differ from the tutorials. Even though it is in direct query mode also I thought going through the semantic models might add some kind of additional overhead. Any ideas?