Forum Discussion

Gourd_J's avatar
Gourd_J
Icon for Helper I rankHelper I
6 years ago

"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 t...
dataset connection
Paginated Report
ReportServer
Gourd_J's avatar
Gourd_J
Icon for Helper I rankHelper I
6 years ago

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?

Balkrishnan's avatar
Balkrishnan
Icon for Helper II rankHelper II
6 years ago

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.

  • Annemie19's avatar
    Annemie19
    Icon for Helper II rankHelper II
    5 years ago

    Balkrishnan ,

     

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

     

    Kind Regards, 

    Annemie

     

Related content