Error changing date type Salesforce Objects

[Paulien1989]

I keep getting this error:

DataSource.Error: Non-grouped query that uses overall aggregate functions cannot also use LIMIT

While all I want to do is change a column type from Date/Time to Date. The source is Salesforce Objects.

This is the first time this happens, I work with Salesforce Objects all the time. Any thoughts?

[v-qiuyu-msft]

Hi @Paulien1989,

I got below information from PG:

It's a known issue which is defect 10192314 on our backlog. The workaround is to insert a step to buffer the data with Table.Buffer before doing the type conversion.

Best Regards,
Qiuyun Yu

[Paulien1989]

Thanks for your reponse! Uhm.. do you have any idea how I should do that?

[v-qiuyu-msft]

Hi @Paulien1989,

I can reproduce this issue in Power BI desktop latest version. Already reported it internally, will update here once get feedback.

Best Regards,
Qiuyun Yu