Forum Discussion
change detection in live connection models
I decided also to play arround a little bit more.
And i found the solution. You have to enable change detection in live connected reports.
only thing is that you can't do that in PBI desktop (it's greyed out at the moment ?!), however you can do it in pbi web UI.
after i did that, it works as expected.
Community Championfuglphoenix - It doesn't apply to a live connection. Only the original data model requires the change detection, the other live connections are just pointing to this original data model.
so eventhough that original data model has updated with the new data. the live-connected reports doesn't get that data unless you force an update on them?
- Greg_Deckler
fuglphoenix - No, it is a live connection, whatever is in the original data model is reflected in the live connections. When the original data model updates, those updates are automatically reflected in the live data connections. The other connections are live, meaning real time. Think of it as Direct Query versus import. In Direct Query if new rows are added to the database, the next time you click on a report, you get the latest and greatest information from the database, no need to refresh the dataset, you are querying the dataset every time you click on a report. Live connections are the same.
That is also how it thought it would work...
but that is not what i'm seeing. when i update the datasource with the direct query connection, I see the change immediately in the source-model. but the "live" connected models still shows the old data, not even an F5 refresh will update them. I have to click "Refresh" in the ...-menu
- Greg_Deckler
fuglphoenix - That sounds to me like a cacheing issue. I'd be interested to know other people's experiences with that because that is a very common usage model.
Worst case, You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".