Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper 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...
Need Help
Tutorial Requests
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
Icon for Helper V rankHelper 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
      Icon for Helper V rankHelper V
      2 years ago

      I did add that into Dax and get the same error: 
      The query contains the 'PhysicianOrganization' parameter, which is not declared. (Microsoft Analysis Services)

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Karolina411 ,

    Please update the query as below and check if it can get works:

    FILTER(VALUES('Providers'[PhysicianOrganization]), 'Providers'[PhysicianOrganization] = [@PhysicianOrganization] )

     

    Best Regards