topic "Query execution failed for dataset" on a paginated report in Report Server

"Query execution failed for dataset" on a paginated report

Gourd_J — Fri, 31 Jan 2020 17:57:02 GMT

I have a paginated report users run directly on our Power BI Report Server 2017. It contains 10 datasets that access different cubes in our SSAS MD database. If one of the cubes is unavailable when the report is run by users they get an error of "Query execution failed for dataset ____" and the report does not show. Not a friendly message.

Is there a way to elegantly handle this error and inform the user that there is an issue with the data source?

Thanks

Re: "Query execution failed for dataset" on a paginated report

Balkrishnan — Fri, 31 Jan 2020 20:39:17 GMT

I am also getting same error , but the report works fine in Power BI report Builder.

Re: "Query execution failed for dataset" on a paginated report

Gourd_J — Fri, 31 Jan 2020 20:57:45 GMT

Balkrishnan , this is not the same issue as I and having. My data source is unavailable.

For you, on the server did you go into the Manage\Data sources and set your Connection string and Credentials appropriately?

Re: "Query execution failed for dataset" on a paginated report

Balkrishnan — Fri, 31 Jan 2020 21:25:10 GMT

Yes Connection string and Credentials are set correctly.

So only i am able to open this report from workspace using Power BI report Builder.

The problem is when i open the same report from Power BI Service. The parameter are displayed but when loading data i get error.

Query execution failed for dataset 'DataSet_'.
I have three datasets. I can see them in Report Builder.

Re: "Query execution failed for dataset" on a paginated report

Balkrishnan — Mon, 03 Feb 2020 15:28:01 GMT

Any Help on this.

Re: "Query execution failed for dataset" on a paginated report

Gourd_J — Tue, 11 Feb 2020 13:42:00 GMT

Balkrishnan as you can see no one is going to help us on this thread now.

In the future, when you have your own question - make your own post your the forum. If you think your problem is the same as someone elses then simply follow that thread.

When you add your reply to an existing question the post's thread looks like it has activity and other people are less likely to follow up on it because they think it is now being answered. When a post has no replies people are more likely to take a look at the question and try to help. So in the end neither of us is likely to get any help now because there are multiple replies to the post 😞

Re: "Query execution failed for dataset" on a paginated report

Annemie19 — Tue, 10 Nov 2020 17:54:14 GMT

Balkrishnan ,

I am getting the same issue you had. Were you ever able to resolve it?

Kind Regards,

Annemie