Forum Discussion

RajeshZZ424's avatar
RajeshZZ424
Frequent Visitor
3 years ago

Paginated report parameter issue

Hi,

I creating a Paginated report using Databricks as datasource. I have created a Power BI Dataset using Databrciks as Datasource and I added Power BI dataset as Source in paginated report. And Added the dataset from power Bi service which is from Power Bi Dataset and I created a paginated report still here everthing is fine but I have two tables(Datasets) using the report from same power Bi dataset datasource. 

 

There is common column in both the tables which is Condiiton_ID. First table 1) DS_Condition 2) DS_Values

I have created parameter using dataset DS_Condition and it working fine and showing data for DS_Condition where it is used. I have added same parameter for DS_Values it is not working.
 getting error:
The parameter <ccon>@Condition_ID</ccon> is not referred in the query.
----------------------------
Query execution failed for dataset 'PPM_Values'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.

I am goal is to filter data for two Datasets using one condition.. 

 

 

No RepliesBe the first to reply