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 I've already made the report based on an excel file but want to link the report straight into the systems into live data
Sorry It's hard for me to follow you. Let's see if this helps. You can get data from excel file (local, sharepoint, onedrive, etc) into Power Bi. Then you can define when the data will refresh. However you can't make it live. Data from excel can't live connect.
What is "link the report straight into the systems (what system?) into live data"? Do you want a link to online excel (like onedrive)?
Are you talking about adding a button inside the report with the Excel URL? you can do that with buttons actions. You can read more here: https://community.powerbi.com/t5/Service/RLS/m-p/2075712#M139071
Regards,
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.