CDS Source Import to Live Connection

[prakash11440278]

Hi,

How can i change my existing CDS Source connection from Import to LIve connection?

[v-shex-msft · Accepted solution]

Hi @prakash11440278,

You can take a look at the following blog about 'direct query' of CDS on power bi if it meets your requirement:

DirectQuery CDS from Power BI 

In addition, you can also try to use dataverse connector(CDS renamed as dataverse), it allows you to use direct query mode:

What is Microsoft Dataverse? 

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