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

[Karolina411]

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.

[Anonymous]

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]

 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

[Karolina411]

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 

[Anonymous]

Hi @Karolina411 ,

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

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

Best Regards

[Anonymous]

Hi @Karolina411 ,

What is the data type of column 'Providers'[PhysicianOrganization]? Text type or Integer? Please update the filter context as below and check if it can work:

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

Add filters to datasets, data regions, and groups in a Power BI paginated report - Power BI | Micros...

Best Regards

[Karolina411]

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