Forum Discussion
CDS Source Import to Live Connection
Hi,
How can i change my existing CDS Source connection from Import to LIve connection?
Hi prakash11440278,
You can take a look at the following blog about 'direct query' of CDS on power bi if it meets your requirement:
In addition, you can also try to use dataverse connector(CDS renamed as dataverse), it allows you to use direct query mode:
If the above not helps, you can also consider creating a power report with its dataset. You can use power bi service connector to get data from existed datasets with live connection mode. (notice: this 'live mode' connection is an indirect connection to the raw data source and it does not trigger and affect the raw dataset refresh, it keeps to get the last data from the current power bi dataset)
Regards,Xiaoxin Sheng
1 Reply
Hi prakash11440278,
You can take a look at the following blog about 'direct query' of CDS on power bi if it meets your requirement:
In addition, you can also try to use dataverse connector(CDS renamed as dataverse), it allows you to use direct query mode:
If the above not helps, you can also consider creating a power report with its dataset. You can use power bi service connector to get data from existed datasets with live connection mode. (notice: this 'live mode' connection is an indirect connection to the raw data source and it does not trigger and affect the raw dataset refresh, it keeps to get the last data from the current power bi dataset)
Regards,Xiaoxin Sheng