Paginated Report Error when published to Power BI Service

Hi all, 

I have created a  report in Power BI Report Builder, using a query to get the data from Microsoft SQL Server.

The report runs fine in the dekstop app but when i publish it to Power BI Service i get the below error when runing the report. 

I have set the data gateway details also.

I have also created a simple report, querying the same db, and it works.

Thank you for your help,

Ioana