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.
So what I mean is that I have created a report using an excel spreadsheet which i update manually at the moment.
However, I would like to chnage the data source to being a live connection to somehting like business objects for example. Is this possible or will i have to create a new report based on the new source which is live?
Also how different are the dax measures when connecting to a live data source?
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.