Reports using on-premise gateway do not support 'use single transaction when processing the queries'

[DennisGi]

Hi,

I get an error message: Reports using on-premise gateway do not support 'use single transaction when processing the queries' when running a paginated report.

How can I avoid this message? In didn't find any checbox like 'use single transaction'. On the internet I've found a solution where there refer to a setting like this, but in the current version of power bi report builder seems to have lost this setting.

In the paginated report there is 1 datasource & 1 dataset using this datasource. Several parameters with default calculated value, but without a dataset. The datasource is a private azure sql, we use a gateway to connect to the private resources.

Thanks,

Regards,

Dennis

[DennisGi]

Yes, report was migrated from an on-prem report server

[cphite]

If you create a report in Visual Studio, there is a toggle for this setting when you create your data source.  Power BI Report Building is missing the toggle.

[d_gosbell]

Out of curiousity, do you have any idea how this setting got in there? Did you use the publish option from an on-prem server to push this report onto the service or did you use some other process?

[DennisGi]

Indeed... 

I've deleted the line: <Transaction>True</Transaction> and it works!

Thanks!

Regards,

Dennis

[d_gosbell · Accepted solution]

Was this report migrated from an on-prem report server? Have you tried searching through the .rdl file with a text editor to see if there are any properties in there with "transaction" in them?