Powerbi Report Builder

[simona0808]

Hi everyone!

I have been getting this error for days and cannot solve it. I am getting this message whenever I run the report. I am connected to a PowerBi dataset from the app.

The result set returned by the server is not a rowset.
----------------------------
Query execution failed for dataset 'DataSet1'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.

It is my first time making a paginated report and working with PowerBi Builder. So, if anyone has any suggestions on how I can solve the error I will be very happy to hear!

Thanks for the help.

[bradsy]

The query needs to return a dataset. This article might help you. https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-qu...