Changes are not being shown real-time

You need the data from the writeback table to be loaded into your Power BI model (analysis services) in a “real time” scenario.

The visual only allow data to be visualize that comes from the Power BI model (Analysis service). The beauty of this is that it enables you to utilize all the power of DAX and other Power BI functionality like security etc.

For this you have several options:

Option 1: Composite Models Option 2: Mixed Mode Option 3: Azure Analysis Services