Forum Discussion
Reports using on-premise gateway do not support 'use single transaction when processing the queries'
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
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?
5 Replies
- d_gosbell
Super User
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?
Indeed...
I've deleted the line: <Transaction>True</Transaction> and it works!
Thanks!
Regards,
Dennis
- 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?
cphiteHelper I
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.
Yes, report was migrated from an on-prem report server