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..
