Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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],
Solved! Go to 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 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"),
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
Changing all the queries to using Dataverse insteadof CDS solved it thanks