Forum Discussion

Karolina411's avatar
Karolina411
Helper V
2 years ago

Seriously need help with Report Builder Query functions - I am using a Saas/Tabular Model

I am attaching the .rdl file in hopes of desperate support with a field in my data set 

 

Step 1

 

Here is my dataset (from a Tabular SAAS model)

 

 

Step 1b

 

Step 2

 

 

Step 3

 

 

 

Result when I run the report

The end of the input was reached.

----------------------------

Query execution failed for dataset 'DataSet1'.

----------------------------

An error has occurred during report processing.

----------------------------

An error occurred during local report processing.

Need Help
Tutorial Requests

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Karolina411 ,

    The error message "The end of the input was reached" often indicates a syntax error or an incomplete command. Please ensure all table and column names are correct, and the syntax follows the DAX pattern. If you can get some data displayed after you click the link "Click to execute the query"? Besides that, please ensure that fields in your report match the fields in your dataset.

     

    In addition, you can refer the following link to query a SSAS Tabular model database:

    How to query a SSAS Tabular model database using DAX functions

    Best Regards

    • Karolina411's avatar
      Karolina411
      Helper V
      2 years ago

      Thank you.  The dataset worked perfectly until I added the PhysicianOrganization PARAMETER.  it did not work when I selected 'Add from dataset' so I had coded the 7 options like the photo below.  I then referenced it in my dataset like this: FILTER(VALUES('Providers'[PhysicianOrganization]), ('Providers'[PhysicianOrganization] = VALUE(@PhysicianOrganization))

      I then added it to the dataset 

       

       

       

    • Karolina411's avatar
      Karolina411
      Helper V
      2 years ago

       added the Parameter under Parameters then added to the Query and Dax and get the same error: 
      The query contains the 'PhysicianOrganization' parameter, which is not declared. (Microsoft Analysis Services)

      Though I did add it in it is not recognizing it.  It is a Text Column