Scheduled refresh with Dynamics CRM as datasource not working

[theferret]

Hi

Just published out a new report that only has Dynamics CRM as its source. Refreshes manually fine, but when I tried to set up a scheudled refresh says "you cant schedule refresh for this dataset as it doesn't suport refresh".   Any ideas why this is an issue as seems very odd? Is this some setting in CRM?   Any help appreciated

My source is

Source = Cds.Entities("https://xxxx.api.crm11.dynamics.com", [ReorderColumns=true, UseFormattedValue=true]),
    entities = Source{[Group="entities"]}[Data],

[Greg_Deckler · Accepted solution]

@theferret What connector are you using? I believe you should be using the Dataverse connector and your source line should be something like:

Source = CommonDataService.Database("xxx.crm.dynamics.com"),

[theferret]

I think this was using CDS conenctor that i copeid form an old model.  I tried going to Dynamics 365 (Dataverse). it asks me to sign in then says unable to connect delte crednetials. I cleared the permissions in Power Query, but is this different credentials?

Thanks

[theferret]

Changing all the queries to using Dataverse insteadof CDS solved it thanks