Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |