Forum Discussion
RLS
Ok. When you get data from excel you can't create a live connection. You can make it refresh with schedule (8 times a day with pro or 48 times a day with premium). If you think that's not enough for the report or users, then you need to change the source.
I think what you are looking for is "Direct Query". It's a different kind of connection you can use against a certain database engines. That kind of connection will through a query to data when changes on report are clicked. It has a cache that makes it almost live. However you really need to understand that connecting data that way needs a preparation. Connections and engine must be strong to receive everytime a query. Measures can be built with some limited functions, but the most important ones should be there.
I hope that helps,
P/D There is not such thing as live data. The most close is building a streaming structure with code.
Hi. Let's see. I would like to say something first. The RLS is a configuration from a Dataset. That means it's not from a report. You can have multiple reports connected to a single dataset with RLS. All reports will have same RLS.
What do you mean with chango to live. You can't change an excel to live. The only live connections that work on Power Bi are Analysis Services and PBI Datasets. If you have configured RLS in one of those last sources then it doesn't matter if you create a new report live connected to that. The RLS is active because it's part of the dataset/model.
On the other hando, the subscription might be attached to the report. If you delete it and publish back again it will be lost. But if you replace the report like updating, it will keep there. You can always reconfigure it if you need.
I hope this make sense