Forum Discussion
"Query execution failed for dataset" on a paginated report
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
6 Replies
I am also getting same error , but the report works fine in Power BI report Builder.
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?
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.
